Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
There's no built-in function to get the month-end date, but you could use DATE2 to get yyyymm and then use IFTHENs to add the correct dd for mm (if you need to cover leap years, you'll need a bit of logic for that as well). |
|