Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
daniel_f
Creator
Creator

Date & time format

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

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try Timestamp#() function

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jmvilaplanap
Specialist
Specialist

Hi,

You have to convert it to date, you can use the Date# function

Date#(yourDateField, 'YYYYMMDDhhmmss')

Regards

vishsaggi
Champion III
Champion III

Try this?

= Date(Date#('20170807121648',  'YYYYDDMMhhmmss'), 'MM/DD/YYYY hh:mm:ss')

Not applicable

Try this working fine....

Timestamp(Date#('20170807121648',  'YYYYDDMMhhmmss'))

its_anandrjs

You can use Makedate() or Timestamp() functions for the same.

Regards,

Anand