Date to Quarter

[Anonymous]

Hi All

Anybody help me for date conversion. Any useful document?

In my case I am unable to create quarter.

Sample attached..

[marcus_sommer]

Try it with ceil(month(date) / 3) as quarter.

- Marcus

[buzzy996]

Ceil(Month([ur field])/3) As Quarterly,

[Anonymous]

I get null value, somehow

Thanks Marcus

[Anonymous]

Hi Shiva again null value for attached QV

Thanks

[marcus_sommer]

Replace date with your date-fieldname and make sure that it is really a numeric date:

ceil(month(YourDateField) / 3) as quarter

- Marcus

[Anonymous]

Marcus

I needed to change formula as

ceil

(month(Date(Date#(vDate,'DD-MMM-YY'), 'MM/DD/YY')) / 3)

[its_anandrjs]

Hi,

Check the attached file

For quarter conversion write like

'Q'&Ceil(Num(Month(Date(Date#(vDate,'DD-MMM-YY'), 'MM/DD/YY')))/3)

Regards

Anand

[Anonymous]

Hi Shiva

I needed to change formula as

ceil

(month(Date(Date#(vDate,'DD-MMM-YY'), 'MM/DD/YY')) / 3)

Thanks for your suggestion and time

[Anonymous]

Marcus; Thanks for your suggestion and time