topic Re: Date conversion from character in Application Development and Automation Discussions

Date conversion from character

Former Member — Tue, 26 Feb 2008 11:02:19 GMT

Hi all

i am having date in variable which is charter data type. i tried to save it in a varible which is data type of D. while moving to this date field it is not moved in correct date formate.how can i move it in a date formete from character data type to Date field.

Re: Date conversion from character

Former Member — Tue, 26 Feb 2008 11:06:06 GMT

Hi,

Since you have ur data in a char variable, try to use the string functionalities to get ur data in the format of YYYYMMDD. Then try moving the data to the variable of type D.

This would surely get you the expected result.

<REMOVED BY MODERATOR>

Kiran S

Edited by: Alvaro Tejada Galindo on Feb 26, 2008 2:25 PM

Re: Date conversion from character

JozsefSzikszai — Tue, 26 Feb 2008 11:06:45 GMT

hi Joe,

the date format has the following format internally: YYYYMMDD. This means your character variable has to be the same format, like 20080226 for today. Otherwise you won't be able to move the value.

hope this helps

Re: Date conversion from character

Former Member — Tue, 26 Feb 2008 11:08:57 GMT

Hi,

Your character variable format should be YYYYMMDD, then it will work.