Notifications
Clear all
Topic starter
I'm working to create a display by calendar year. If the criteria has been met, then the user would see a display stating - "Criteria met for 2017" so the display would then be "reset" after 12/31/2017 and on 1/1/2018 the measure would then have to be met. Most of what I have done previously has gone by a year from the entry date, but this group would really like for that to change so that they use a calendar year instead.
Any suggestions on this would be most welcome.
Posted : January 3, 2017 8:03 am
I'm not sure if this is what your looking for. The following will give you the current year.
sub(str(._TODAYSDATE),7,4)
Example - 2017
You could use that to compare.
Posted : January 4, 2017 8:55 am
