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.

 

Bill

Outcomes