How shall the WHERE clause look for this challenge:
Pseudocode: select all records from file where datefield (ccyymmdd 8.0) shall be greater than todays month minus 36 months.
As you can see this may be expressed as [em]rolling 36 full months plus current month[/em].
Any help will be apreciated.
September 4, 2009 4:45 PM
September 7, 2009 1:19 PM