Date Formats

[#1]

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

[gautik92]

you have a create a master calendar to achieve this

[alexandros17]

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)

[MK_QSL]

use below blog post...

Fiscal Year