Dates

[Pickering, John (NORBORD)]

>I am using 8.19 on an HP3000. I have a date field which is YYYYMM. I
>need to run a QTP procedure to update this field every morning. It needs to
>be 2 months less than the current date. The problem Im having is when the
>year 2000 comes around. Thank you for your help in advance.

I'll assume the YYYYMM field is X*6. If wrong then adjust the following to
suit.

How about:

>define d-2months-ago char*6 &
>  = ascii(date(days(nconvert(YYYYMM + "01")) - 35),8)[1:6]

John Pickering
Toronto
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.