Logic help to create date & Time.

[lalitkgehlot89]

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

[Anonymous]

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