Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to create fiscal year from given date
Hi,
Use YearName(DateField,0,4)
Regards,
LOAD *,
Day(date) as day,
Month(date) as month,
Year(date) as year,
yearname(date,0,4)as FinancialYear;
hi
Try some thing like this
=Year(date('date field','DD/MM/YYYY))
Try this:
[Requesterdate] means your date field in the Data ..
right(year(addmonths([Requester Date],-3)),2) & '-' & right(year(addmonths([Requester Date],-3))+1,2)