topic Date formate in QlikView

Date formate

Tue, 17 Apr 2012 11:10:25 GMT

in my script Date are given in text formate(eg- 01-Jul-2011) then how can i change date in number format(01-07-2011)...

rajni_batra — Tue, 17 Apr 2012 11:17:03 GMT

Try

date(currentdatefield,'DD-MM-YYYY') as Newdate

Tue, 17 Apr 2012 11:19:52 GMT

thanks for the reply but this is not working...

rajni_batra — Tue, 17 Apr 2012 11:20:51 GMT

Can u forward any sample for this?

rajni_batra — Tue, 17 Apr 2012 11:21:45 GMT

there can b some problem with time function attached with Date

try to link with the num(datefield) in fact and calender

Tue, 17 Apr 2012 11:26:05 GMT

I am providing the tex file which containing the data....

SunilChauhan — Tue, 17 Apr 2012 11:29:16 GMT

makedate(right('01-Jul-2011',4),Mid('01-Jul-2011',4,3),left('01-Jul-2011',2))

or for a field

makedate(right(Datefield,4),Mid(Datefield,4,3),left(Datefield,2))

Tue, 17 Apr 2012 11:29:50 GMT

I am also giving u qvw file

SunilChauhan — Tue, 17 Apr 2012 11:35:36 GMT

i thing duedate and date are one and same

you can use this

=makedate(right(Date,4),Mid(Date,4,2),left(Date,2))

hope this helps

CELAMBARASAN — Tue, 17 Apr 2012 12:14:44 GMT

Hi,

Check with this

Date(Date#(DateField,'DD-MMM-YYYY'),'DD-MM-YYYY')

Celambarasan

Tue, 17 Apr 2012 12:25:29 GMT

Thanks for the answer sir....