Page 1 of 1

date conversion

Posted: Wed Apr 09, 2008 1:10 pm
by syam.neelam
What are the conversion steps to convert the date from dd/mm/yy yo mm/dd/yy

Posted: Wed Apr 09, 2008 3:24 pm
by ray.wurlod
DateToString() and StringToDate() functions with appropriate format strings.

Re: date conversion

Posted: Thu Apr 10, 2008 1:18 am
by naveen19
Hi,
Try this stage variable but data type should be varchar
Right(columnname,2) :'/' : Field(columnname,1) :'/' : Field(columnname,4)


Regards
Naveen.K

Posted: Thu Apr 10, 2008 3:29 pm
by ray.wurlod
Field() function requires a minimum of three arguments. And the question was posed with Date as the data type.