Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help in converting the timestamp in below fornmat to MM/DD/YYYY hh:mm:ss
Wed Aug 9 06:00:00 2017 - 08/09/2017 06:00:00
Hi,
Try Date(Field, 'MM/DD/YYYY hh:mm:ss')
Hi,
Try
=TimeStamp(TimeStamp#(SubField('Wed Aug 9 06:00:00 2017 - 08/09/2017 06:00:00', '- ', 2), 'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY hh:mm:ss')
Timestamp(Timestamp#(Subfield('Wed Aug 9 06:00:00 2017 - 08/09/2017 06:00:00','-',2),'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')
Hi Binod,
U might have got the answer if u have seen above replies. Anyways. Try this.
Timestamp(Timestamp#(Subfield('Wed Aug 9 06:00:00 2017 - 08/09/2017 06:00:00','-',2),'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')
Hi Binod,
Please Try Below:
Try
=Date(TimeStamp#(SubField('Wed Aug 9 06:00:00 2017 - 08/09/2017 06:00:00', '- ', 2), 'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY ')
Thanks,
Arvind Patil
Try this it will work
=date(date#(Mid('Wed Aug 9 06:00:00 2017',5),'MMM DD hh:mm:ss YYYY'),'MM/DD/YYYY hh:mm:ss')
Hi All,
Sorry for the confusion
Please help in converting the timestamp in below fornmat to MM/DD/YYYY hh:mm:ss
This is the input format - Wed Aug 9 06:00:00 2017
Expected Output - 08/09/2017 06:00:00
=TimeStamp(TimeStamp#(Mid('Wed Aug 9 06:00:00 2017',Index('Wed Aug 9 06:00:00 2017',' ')+1),'MMM D hh:mm:ss YYYY'),'MM/DD/YYYY hh:mm:ss')
hth
Sasi
Hi Vinod
Have you come alright with your problem?
Sasi