AnsweredAssumed Answered

Find formula confusion

Question asked by wcallman on Dec 24, 2018
Latest reply on Jan 5, 2019 by philmodjunk

I need to create a find on a dataset:


Find all students in Program YRY (understand this one)

also in the same find I need to constrain based on the following criteria:


Exit Date = CM/CY (included in find)

Exit Date < CM/CY (omitted)

Exit Date is Blank (included in find)

where cm=current month and cy = current year


I am stuck writing the script to get CM and CY

I always get hung when I need to constrain a find in a script.


Any thoughts will be appreciated


Merry Christmas and Happy Holidays to all.

thank you for any insight.

If someone knows of an article showing multiple constrains in a find please advise.