Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a date field and need to fetch FiscalYear, FiscalQuarter, Month, Week# and Day# from it.
Example :
DateField : 14/4/2015
Output:
FiscalYear: 2015-2016
FiscalQuarter: Q1
Month : Apr
Week# : 15
Day# : 14
Regards,
Keerthi KS
you have a create a master calendar to achieve this
DateField : 14/4/2015
Output:
FiscalYear: Year(DateField) & '-' & Year(DateField)+1
FiscalQuarter: If(Month(DateField)<4,'Q1',If(Month(DateField)<7,'Q2',If(Month(DateField)<10,'Q3','Q4')))
Month : Month(DateField, 'MMM')
Week# : Week(DateField)
Day# : Day(DateField)
use below blog post...