| Function group | Execute on client | Platform(s) |
|---|---|---|
| Date and Time | NO | All |
setfye(date)
Sets the date of the fiscal year end.
The date does not have to be in the current year, that is, the function ignores the year part of the date. The setting of the fiscal year end affects all other date functions that involve quarters. It returns the previous value so you can save it for later use.
Calculate lDate as setfye('MAR 31')
# sets the fiscal year end to March 31st
Calculate lDate as setfye('12 31 03')
# sets the fiscal year end to December 31st and ignores the year