Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert a utc number to real date

Hello

I would like to convert a UTC number to a date stamp

i get this valuew from a intershop logfile numbers look like this and is the milliseconds from 01-01-1970

Is there any ony one who can help me

regards

Chrisz

these are some of the numbers

1302472796254

1302472796410

1302472796582

1302472796598

1302472797051

1302472797066

1302472797082

1302472797145

1302472797207

1302472797848

12 Replies
Miguel_Angel_Baeyens

Hi,

UTC() always returns real time (and gets updated every second) in UTC format, regardless the parameters you pass on it, so UTC(Now(2)), UTC(ABC) and UTC(2) and UTC() will return the same (at least in version 10 SR2). So it will always return the same date (now) regardless the value it gets from the field.

It would be great though if parameters will not be allowed or it throw an error when something is set within the brackets.

Hope that helps

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable
Author

Thanks Miguel, fixed the typo in original post.

Not applicable
Author

THank you all guys and girls

for you support

cheers

Chrisz