Home › Forum › Behaviors › What are the units for the Date Difference function? › Re: What are the units for the Date Difference function?
I have a question regarding date calculation – how should I calculate whether or not an entered date falls within this current fiscal year (from 9/1 to 8/31).
So far I have a good structure in arranging my elements for this calculation, but I am unable to figure out how to accomplish “year + 1” or “year – 1”. Not sure if there is any related function for this, or if I miss anything.
Below is my current logic:
Determine current fiscal year (f_year):
If month(today) >= 9 then f_year = year(today)
If month(today) < 9 then f_year = (year(today) – 1)
Determine if the entered date falls within this current fiscal year:
Check If ( (month(entered_date) >= 9) & (year(entered_date) = f_year) )
OR
( (month(entered_date) < 9) & (year(entered_date) = (f_year + 1) )
Thanks.