Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
can someone please advise what the best way to convert the format date time: "20170807121648" to date and time in order to later find the max\maxstring?
thanks in advance,
Daniel
Try Timestamp#() function
Regards,
Kaushik Solanki
Hi,
You have to convert it to date, you can use the Date# function
Date#(yourDateField, 'YYYYMMDDhhmmss')
Regards
Try this?
= Date(Date#('20170807121648', 'YYYYDDMMhhmmss'), 'MM/DD/YYYY hh:mm:ss')
Try this working fine....
Timestamp(Date#('20170807121648', 'YYYYDDMMhhmmss'))
You can use Makedate() or Timestamp() functions for the same.
Regards,
Anand