on 09-20-2007 3:18 PM
Post Author: keiths
CA Forum: Formula
Basically, I need to exclude all records that occur on the first day of each month regardless of year or month. session_date <> (any, 01, any) I'm new to programming... if you can't already tell. Thank you in advance for your input.
Post Author: SKodidine
CA Forum: Formula
Well, instead of checking the whole date, just check for the Day like this:
Day(session_date) <> 01
This way, no matter what the year or month is, if the day is equal to 1, then the record will not be selected.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.