Date conversion from character

[Former Member]

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.

[Former Member]

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

[JozsefSzikszai]

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

ec

[Former Member]

Hi,

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