Date formate

[#1]

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]

Try

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

[#3]

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

[rajni_batra]

Can u forward any sample for this?

[rajni_batra]

there can b some problem with time function attached with Date

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

[#6]

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

[SunilChauhan]

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

[#8]

I am also giving u qvw file

[SunilChauhan]

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 · Accepted solution]

Hi,

     Check with this

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

Celambarasan