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.