Calculate the date range of the last Complete 6 months.

[Al Smith]

Hi,
I've been working on this for hours and can't come up with the proper code.
I need to calculate the date range for the last complete 6 months in either yyyymmdd or yymm format. e.g. 19990901 to 20000229 or simply 9909 to 0002.
I've tried the year with the month function but get 99 9 instead of 9909.
Any assistance will be greatly appreciated.
Thanks,
Al.

[MartinLiss]

Look up the Format function. If that doesn't help, post some of your code and I sure someone vcan help you.

[Al Smith]

Hi,
I didn't have any code. I was working in the Immediate window simply trying to get the date ranges to print. I was also using the Format function.
But since my post I found the DateAdd function which I didn't know about. I think it will serve my purposes.

Print format(DateAdd("m",-6,date),"yymm")
Print format(DateAdd("m",-1,date),"yymm")

Thanks,
Al.