I am trying to trim both my target date and today's date in order to compare <= by year. My expression has become quite complicated at this point. Is there an easier way? If not, how do I achieve the output I'm looking for?
Example: 2016-01-20 (Target Date trimmed to year only) <= the current year (today's date trimmed to year only)
DateTimeTrim(DateTimeToday(),"month"&&"day")
Ready...Set...Go!
Thanks,
MandyJ
Solved! Go to Solution.
DateTimeFormat formula should do the trick I believe (formats the field in question to show just the year):
DateTimeFormat([Field1],"%Y")<=DateTimeFormat(DateTimeToday(),"%Y")
NJ
Thank you, Nicole! Worked perfectly! I was thinking it through entirely too hard.