Discussion board where members can get started with Qlik Sense.
I have a time stamp format like : [14/Sep/2016:10:40:00 +0800]
I tried the below formula :
Timestamp(Timestamp#(Left("Timestamp",11)&' '&Right("Timestamp",9),'DD/MMM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss') as "User Timestamp"
but the resultant is coming like : 9/13/2016 10:40:19 AM and i want the output as 13/9/2016 10:40:19 wthout AM/PM.
You are loosing 1 day also? Sep 13 vs Sept 14 or is that a typo?
yes it is the typo.. its 13th sept.
This works for me:
=Timestamp(Timestamp#(Left(Timestamp, 20), 'dd/MMM/yyyy:hh:mm:ss'), 'd/M/yyyy hh:mm:ss')
14/Sep/2016:10:40:00 +0800 --> 14/9/2016 10:40:00
This simplest solution to formatting a date would be to convert it to a number and then apply the date format you want. In your case, you can try something like this,
Hope this will be helpful.
If anything above has worked , you can close the discussion.