Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my data set I appear to be receiving a date in an unusual format. It's numeric (e.g. 1355833734) and it turns out that it's the number of seconds since 1/1/1970.
Below is one way of converting it:
ConvertToLocalTime(Date(MakeDate(1970, 1, 1) + (call_date / 86400)), 'Athens') as CallDate
Are you aware of a better way that makes it less "regional"
Thanks in advance
Alexis
Yes that is what I did in the end!
I think it is correct as it was Celambarasan as it "seconds" from 1/1/1970 - I am assuming it is from 01/01/1970 00:00:00