Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
How can I get a date in format YYYY-MM-DD h:mm:ss TT?
=If(Auto_Id=1519,Timestamp((num(date#(TimeStamp, 'YYYY-MM-DD h:mm:ss[.fff] TT'))-0.0417)), 'YYYY-MM-DD h:mm:ss[.fff] TT')
I got in result 9/13/2015 2:40:49 AM
Thanks,
What is the format of your TimeStamp field?
'2015-09-13 3:42:09 AM'
I got it
Timestamp((num(date#(TimeStamp, 'YYYY-MM-DD h:mm:ss[.fff] TT'))-0.0417),'YYYY-MM-DD hh:mm:ss TT' )
just remove .[fff]
=TimeStamp(TimeStamp# ('2015-09-13 3:42:09 AM','YYYY-MM-DD h:mm:ss TT')-0.0417,'YYYY-MM-DD h:mm:ss TT')
replace '9/13/2015 2:40:49 AM' with your field
=Timestamp(Timestamp#('9/13/2015 2:40:49 AM', 'MM/DD/YYYY hh:mm:ss TT'), 'YYYY-MM-DD h:mm:ss TT')
the bold part is from text to num (interpretation function, Timestamp#)
the non bold part is from num to text (formatting function (Timestamp)
more here