Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, below given data in text format. I want to convert it into Timestamp (DD-MM-YYYY hh:mm:ss) format.
Please help to convert it.
2018/5/30 0:0:0 |
2018/5/30 0:10:0 |
2018/05/30 0:10:0 |
2018/12/30 0:10:0 |
2018/1/3 0:10:0 |
2018/1/3 10:10:15 |
2018/1/23 10:10:15 |
2018/10/23 10:10:15 |
Hi,
Just try Following script,
Timestamp(MakeDate(Year(Date#(SubField(Dates,'/',1),'YYYY')),Month(Date#(SubField(Dates,'/',2),'MM')),KeepChar (Subfield(SubField(Dates,' ',1),'/',3),'0123'))&' '& MakeTime( hour( SubField(Dates,' ',2)),Minute( SubField(Dates,' ',2)),Second( SubField(Dates,' ',2)))) as TimeStamp
My result is as follow
May this will help you