date conversion

[syam.neelam]

What are the conversion steps to convert the date from dd/mm/yy yo mm/dd/yy

[ray.wurlod]

DateToString() and StringToDate() functions with appropriate format strings.

[naveen19]

Hi,
Try this stage variable but data type should be varchar
Right(columnname,2) :'/' : Field(columnname,1) :'/' : Field(columnname,4)


Regards
Naveen.K

[ray.wurlod]

Field() function requires a minimum of three arguments. And the question was posed with Date as the data type.