Date Format YYYYMMDD

andy76

Hello,

I ask you help for a strange problem: I have a text file with a date 20091014 - YYYYMMDD but the Format function as following does not run:

MESSAGE(FORMAT(myVar,0,'<Year4><Month,2><Day,2>'));

Why? Which is the correct way?

Thank you

Luc_VanDyck

When you need to format a date, myVar must be a variable of type ... Date:

myVar := '20091014';
EVALUATE(intDay,COPYSTR(myVar,7,2));
EVALUATE(intMonth,COPYSTR(myVar,5,2));
EVALUATE(intYear,COPYSTR(myVar,1,4));
myVarDate := DMY2DATE(intDay,intMonth,intYear);;
MESSAGE(FORMAT(myVarDate,0,'<Year4><Month,2><Day,2>'));

matttrax

Does not run does not tell us what is wrong Be specific about the error you are receiving.

andy76

Hello,

this is my code:

MESSAGE(FORMAT(COPYSTR(lSingleLineFileText,91,8),0,'<Year4><Month,2><Day,2>'));

where COPYSTR(lSingleLineFileText,91,8) i a Text of date in format YYYYMMDD and attach the error message.

Thank you

andy76

Example of date is : 20091014

Luc_VanDyck

What part of my response "When you need to format a date, myVar must be a variable of type ... Date:" don't you understand?

Slawek_Guzek

andy76 wrote:

MESSAGE(FORMAT(COPYSTR(lSingleLineFileText,91,8),0,'<Year4><Month,2><Day,2>'));

where COPYSTR(lSingleLineFileText,91,8) i a Text of date in format YYYYMMDD

You answered your question yourself....

Have you tried MESSAGE(COPYSTR(lSingleLineFileText,91,8)) ??

Slawek