In a message dated 99-09-17 11:30:13 EDT, you write:
I am trying to write a formula that says?if the “ship date” is in the
current month (not rolling 30 days, but month of September) then return the “order value”. The “ship date” object includes the month, day and year.
Can anyone tell me if this is possible?
I didn’t test this for absolute syntax, but try something like:
If (Year() = Year(CurrentDate())) AND (Month() = Month(CurrentDate())) Then Else 0
Leave off the “else 0” if you want the result to be blank instead of zero. Don’t forget to check both the year and the month, or else you end up with a “September” object, not a “September this year” object!
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)