Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)...
Hi,
Check with this
Date(Date#(DateField,'DD-MMM-YYYY'),'DD-MM-YYYY')
Celambarasan
Try
date(currentdatefield,'DD-MM-YYYY') as Newdate
thanks for the reply but this is not working...
Can u forward any sample for this?
there can b some problem with time function attached with Date
try to link with the num(datefield) in fact and calender
I am providing the tex file which containing the data....
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))
I am also giving u qvw file
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
Hi,
Check with this
Date(Date#(DateField,'DD-MMM-YYYY'),'DD-MM-YYYY')
Celambarasan