topic Re: My Date# function is not working properly in QlikView

My Date# function is not working properly

Wed, 08 Jan 2014 13:57:27 GMT

Hi All,

Iam trying to use the Date# function in my script but ut's not working.

Original Date:- 08/23/2013 16:45:10

Expected Output:- 23/08/2013 16:45

I have used function date#('Origanal_Date', 'DD/MM/YYYY HH:MM')

but it returing the same data i.e 08/23/2013 16:45:10.

Can anyone help me on this.

Thanks,

D J

datanibbler — Wed, 08 Jan 2014 13:59:49 GMT

Hi dhiraj,

try timestamp fct.

HTH

Best regards,

DataNibbler

Wed, 08 Jan 2014 14:01:21 GMT

Try...
date(date#(Original_Date, 'MM/DD/YYYY HH:MM:SS'),'DD/MM/YYYY HH:MM')

Anonymous — Wed, 08 Jan 2014 14:04:34 GMT

Small correction

date(date#(Original_Date, 'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm')

It is case-sensitive. MM is for months, mm is for minutes.

Regards,

Michael

maxgro — Wed, 08 Jan 2014 14:06:09 GMT

=date(date#('08/23/2013 16:45:10', 'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY hh:mm')

Wed, 08 Jan 2014 14:08:47 GMT

Timestamp((Date(SubField(Original_Date,' ',1),'MM/DD/YYYY')+Time(SubField(Original_Date,' ',2),'h:mm')),'MM/DD/YYYY hh:mm')

The above is working.

Thanks all for your help and valuable suggestion.

Thanks,

D J