Extract Year, month and quarter from 5 digit date

[egbert_jones]

Hi I'd like to know how to extract Year, month and quarter from 5 digit date ie

Date_Field,

42619

[Anil_Babu_Samineni]

Try this?

Year = Year(FieldName)

Month = Month(FieldName)

Quarter = ='Q' & ceil(month(FieldName)/3)

[shraddha_g]

For CalendarYear,

Year = Year(Date(num#(Date_Field)))

Month = Month(Date(num#(Date_Field)))

Quarter = 'Q' & ceil(Month(Date(num#(Date_Field)))/3)

For Fiscal Year,

Year = Yearnem(Date(num#(Date_Field)),0,4)    ........ Year Starting from Apr

Month = Month(Date(num#(Date_Field)))

Quarter = if( Wildmatch(Month(Date(num#(Date_Field))),'Apr','May','Jun'),'Q1',

                         if( Wildmatch(Month(Date(num#(Date_Field))),'Jul','Aug','Sep'),'Q2',

                                   if( Wildmatch(Month(Date(num#(Date_Field))),'Oct','Nov','Dec'),'Q3',

                                             if( Wildmatch(Month(Date(num#(Date_Field))),'Jan','Feb','Mar'),'Q4'))))