Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
As I am stuck while converting a field into timestamp format. My sample Data looks like below and I have attached the sample excel file.
|
Expected output = 'DD-MM-YYYY hh:mm:ss'.
Thanks in advance.
=date(date#('1/17/2017 8:28:11AM','M/DD/YYYY h:mm:sstt') , 'DD-MM-YYYY hh:mm:ss' )
Try like:
=TimeStamp(Timestamp#('1/17/2017 8:28:11AM', 'MM/DD/YYYY h:mm:ssTT'),'DD-MM-YYYY hh:mm:ss')
Hi,
Ya its working fine if we use that in front end.
But the problem is if I load that Excel file and then use that in script its not working.
Could u please load the Excel file which I have attached and convert that field to Timestamp.
Thanks
I don't find any excel attached.
Sorry for that.
Please find the attachment.
Try:
TimeStamp(Timestamp#([Email Sent Date], 'MM/DD/YYYY h:mm:ssTT'),'DD-MM-YYYY hh:mm:ss') as NewDate
In addition,
you will get the same result with using Date function.
Date(Date#([Email Sent Date], 'MM/DD/YYYY h:mm:ssTT'),'DD-MM-YYYY hh:mm:ss') as NewDate