topic Date format issue in output in QlikView

Date format issue in output

Thu, 20 Mar 2014 13:57:58 GMT

Hi, I am new to qlikview, can someone please help me to correct date format in my report, my input table has date as "26-07-2001".

I have extracted minimum date using Date(min(datefirstpurchase),'dd-mm-yyyy') as MinDate, but in output i am getting minimum date as '01-00-2001', i am getting month value as '00'. do i need to change my expression, please suggest...

Re: Date format issue in output

PrashantSangle — Thu, 20 Mar 2014 14:06:11 GMT

Hi,

If it is date format then there is no need to use date() function

You can directly use min(datefirstpurchase)

If not then you have to first give him formatting then use in min()

Like,

min(Date(Date#(datefirstpurchase),'DD-MM-YYYY'))

Regards,

Re: Date format issue in output

its_anandrjs — Thu, 20 Mar 2014 14:08:02 GMT

Hi,

write like

=Date(Date#(min(datefirstpurchase),'DD-MM-YYYY'),'DD-MM-YYYY')

Thanks & Regards

Re: Date format issue in output

ThornOfCrowns — Thu, 20 Mar 2014 14:08:27 GMT

There is a difference in mm and MM as mm = minutes and MM = month, so dd-mm-yyyy will not bring back the same result as dd-MM-yyyy.

Re: Date format issue in output

sunilkumarqv — Thu, 20 Mar 2014 14:16:19 GMT

Try like these

=min(Date(Date#(datefirstpurchase),'DD-MM-YYYY')) as MinDate

or you can simply use =min(Date(datefirstpurchase,'DD/MM/YYYY')) as Min Date

and below Gives you wrong result

=Date(Date#(min(Date),'DD-MM-YYYY'),'DD-MM-YYYY')

Re: Date format issue in output

Anonymous — Thu, 20 Mar 2014 14:20:34 GMT

you need to write date format in upper case like 'DD-MM-YYYY'. Correctly said by James.

Re: Date format issue in output

Thu, 20 Mar 2014 14:48:00 GMT

Thank you so much James, i just changed mm to MM and got out put as '01-07-2001', Thanks a lot ..........

Re: Date format issue in output

ThornOfCrowns — Thu, 20 Mar 2014 14:50:14 GMT

No probs!

Re: Date format issue in output

Thu, 20 Mar 2014 14:53:24 GMT

Thank you so much, i tried removing date but dint get answer in date format. the below expression which you suggested works min(Date(Date#(datefirstpurchase),'DD-MM-YYYY'))...

Re: Date format issue in output

Thu, 20 Mar 2014 14:55:05 GMT

Thank you so much sunil both the expressions suggested by you works ....