Date format issue in output

[#1]

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...

[PrashantSangle]

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,

[its_anandrjs]

Hi,

write like

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

Thanks & Regards

[ThornOfCrowns · Accepted solution]

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.

[sunilkumarqv]

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')

[Anonymous]

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

[#7]

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

[ThornOfCrowns]

No probs!

[#9]

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'))...

[#10]

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