how to convert 26-FEB-10 into 26/02/2010

pavankatra · Post by **pavankatra** » Wed May 05, 2010 10:22 am

Hi,
I ahve rewuirement like this
how to convert 26-FEB-10 into 26/02/2010

So can anyone suggest me how to do this in parallel job.

Thanks in advance.

anbu · Post by **anbu** » Wed May 05, 2010 11:16 am

Code: Select all

x=26-FEB-10
svMon=UPCASE(Field(x,"-",2))
If svMon = 'JAN' Then '01' Else If svMon = 'FEB' Then '02' ...

pavankatra · Post by **pavankatra** » Wed May 05, 2010 11:46 am

anbu wrote:

Code: Select all

x=26-FEB-10
svMon=UPCASE(Field(x,"-",2))
If svMon = 'JAN' Then '01' Else If svMon = 'FEB' Then '02' ...

Thanks for your reply

i will try it and let you know.

ray.wurlod · Post by **ray.wurlod** » Wed May 05, 2010 4:44 pm

Use StringToDate() to convert to binary date format, and DateToString() to convert back to desired format. Use appropriate date format strings for each function.

pavankatra · Post by **pavankatra** » Thu May 06, 2010 7:27 am

ray.wurlod wrote:Use StringToDate() to convert to binary date format, and DateToString() to convert back to desired format. Use appropriate date format strings for each function. ...

thanks for your reply.

problem solved.

i have created stagvariables to resolve this.

Thanks for your suggestions.