Re: What are the units for the Date Difference function?

[evelina.liuParticipant]

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.