Hi, Im using App Studio 8207.18 and would like to convert a...

[Carol Sundy]

Hi,

Im using App Studio 8207.18 and would like to convert an integer like a ProcessDateKey YYYYMMDD (20210701) to an integer that strips off the day, YYYYMM (202107) Does anyone have a recommendation

Thanks. Carol Sundy

[Carol Sundy]

I know how to convert the integer to a date in YYYYMM format. Is there a way to convert it from a date to integer Thanks.

[David Beagan]

You are looking for something like this

TABLE FILE ggsales

PRINT SEQ_NO

COMPUTE ProcessDateKey/YYMD = &YYMD;

COMPUTE ProcessDateKey2/I8YYMD = ProcessDateKey;

COMPUTE ProcessDateKey3/I8 = ProcessDateKey2;

WHERE RECORDLIMIT IS 1

END

[Charles Morris 2]

try using the DATECVT function - this will change it to different formats and if you get it to an I6YYMD then the integer part is simple

[Carol Sundy]

David, I tweaked 2 of the lines of code and it worked!

COMPUTE ProcessDateKey2/I6YYM = ProcessDateKey;

COMPUTE ProcessDateKey3/I6 = ProcessDateKey2;

Thanks for the suggestion!

Carol

[Carol Sundy]

Charles,

I also tried your recommendation in my meta and it worked!

DATECVT( WEEK_START_YYYYMM, YY|M, I6YYM)

Now I have 2 methods! Thanks so much!

Carol

[Nick Giordano]

Divide by 100thats it!