Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can convert the 14 hour military to 2 a.m EST?
Any ideas?,
thanks
Time(Date) as Date
is it?
Can you share some sample data?
but if what I have is the value 14 in number, I can pass it to standard time?
So just subtract 12
Carlos,
You simply define the time format as TT:
timestamp(YourTimeField, 'hh:mm TT')
For example,
=timestamp('14:00:00', 'hh:mm: TT')
returns 2:00 PM
Regards,
Michael
Thanks Micheal,
makes sense, so TT is for Terrestrial Time