topic Re: Date Conversion in QlikView

Date Conversion

Thu, 25 Jun 2015 11:47:05 GMT

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 — Thu, 25 Jun 2015 11:50:39 GMT

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

MayilVahanan — Thu, 25 Jun 2015 11:52:08 GMT

Try like this

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

PrashantSangle — Thu, 25 Jun 2015 11:52:50 GMT

Hi,

use subfield()

try like

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

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

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

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

Regards

florentina_doga — Thu, 25 Jun 2015 11:53:16 GMT

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

fvelascog72 — Thu, 25 Jun 2015 11:57:32 GMT

Hi, try this:

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

pavendhan — Thu, 25 Jun 2015 12:03:44 GMT

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

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