An alternative way to convert a date?

[alexis]

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

[alexis]

Yes that is what I did in the end!

[alexis]

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