Re: Date Conversion - Qlik Community

Report Inappropriate Content · ‎2015-06-25

Hi

Below is my data

Submited By

1158631: Degalesan, Raghunathan - 02/03/2015 10:48:28 PM#

1158631: Degalesan, Raghunathan - 02/03/2015 10:56:38 PM#

1158631: Degalesan, Raghunathan - 02/03/2015 11:21:16 PM#

1163317: palanikumar raman - 05/03/2015 08:47:23 PM#

1166466: Srinivasan Gayathri - 03/03/2015 07:43:49 PM#

1166466: Srinivasan Gayathri - 04/03/2015 08:46:45 PM#

1166466: Srinivasan Gayathri - 08/03/2015 05:26:02 PM#

Sample Output in the below format

41907.57775

The date , time given in Submitted Column should be shown like above.

arulsettu · ‎2015-06-25

=Date('41907.57775','DD/MM/YYYY hh:mm:ss')

MayilVahanan · ‎2015-06-25

Hi

Try like this

=Timestamp(DateField ,'DD/MM/YYYY hh:mm:ss TT')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

PrashantSangle · ‎2015-06-25

Hi,

use subfield()

try like

Timestamp#(purgechar(subfield(fieldName,'-',2),'#'),'DD/MM/YYYY hh:mm:ss tt')

or

Timestamp(Timestamp#(purgechar(subfield(fieldName,'-',2),'#'),'DD/MM/YYYY hh:mm:ss tt'))

or

Date#(purgechar(subfield(fieldName,'-',2),'#'),'DD/MM/YYYY hh:mm:ss tt')

or

Date(Date#(purgechar(subfield(fieldName,'-',2),'#'),'DD/MM/YYYY hh:mm:ss tt'))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

florentina_doga · ‎2015-06-25

or date('41907.57775','DD-MMM-YYYY')

fvelascog72 · ‎2015-06-25

Hi, try this:

num(Timestamp(date#(SubField(PurgeChar([Submited By],'#'),'- ',2),'DD/MM/YYYY hh:mm:ss TT')))

pavendhan · ‎2015-06-25

=Date(41907.57775,'dd-MM-yy') --> 25-09-14

=Date(41907.57775) --> 9/25/2014