Funny / Weird Date Stuff In Crystal Reports
Hi,
I'm running a report in Crystal Reports which pulls in the end date of a contract. I have located the field in question, maintenancecontract.todate and noted that the date is in epoch format.
I have created a formula in Crystal like the following:
However when I punch in a date like 1172390400000 I get a crazy output of 09/13/1965.
I gather that the number field in Crystal has been exceeded and this is giving me the gibberish output.
Any ideas on whether this can be worked around / fixed?
Thanks,
C
I'm running a report in Crystal Reports which pulls in the end date of a contract. I have located the field in question, maintenancecontract.todate and noted that the date is in epoch format.
I have created a formula in Crystal like the following:
Function (numberVar x)
dateadd("s",x,date(1970,1,1))
However when I punch in a date like 1172390400000 I get a crazy output of 09/13/1965.
I gather that the number field in Crystal has been exceeded and this is giving me the gibberish output.
Any ideas on whether this can be worked around / fixed?
Thanks,
C
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?