I have month and year but cannot get Quarter

[paulyeo11]

Hi All,

Below script from fourm people here work fine :-

SubField([Opportunities Expected Close Date],'-' ,3) as Year,

Num(Month(Date#([Opportunities Expected Close Date], 'MM-DD-YYYY'))) as Month,

Below from me , not working :-

'Q' & ceil(Month(Date#([Opportunities Expected Close Date])),3)/3 as [quarter],

Can some one tell me where i go wrong ?

Paul

[prma7799]

'Q' & ceil(Month(Date#([Opportunities Expected Close Date])),3)/3 as [quarter],

Have you tried this

'Q' & Ceil(Month([Opportunities Expected Close Date]) / 3) AS Quarter,

[paulyeo11]

Hi PM,

Thank you for your help.

No error msg , but does not display value.

Paul

[prma7799]

or you can try like this

     'Q' & ceil(Month(Date#([Opportunities Expected Close Date],'DD/MM/YYYY')),3)/3 as [NewQuarter],

[prma7799]

Take [Opportunities Expected Close Date] field as list box and share screen shot...

[paulyeo11]

Hi PM

Still display nothing. How to convert date format DD-MM-YYYY into Year ? 2 days ago i have ask forum on how to compute the year from my date field on the above link. May be it is due to my date field is quite complicated.

Paul

[prma7799]

have you tried this??

'Q' & ceil(Month(Date#([Opportunities Expected Close Date],'DD/MM/YYYY')),3)/3 as [NewQuarter]

or change date format mention in bold above according to your date

[paulyeo11]

PM

Still Can not.

Paul

[prma7799]

Please share screen shot like below

[pradosh_thakur · Accepted solution]

Year(Date#([Expected Close Date], 'MM-DD-YYYY')) as Year,

Month(Date#([Expected Close Date], 'MM-DD-YYYY')) as Month,

'Q' & ceil(Month(Date#([Expected Close Date], 'MM-DD-YYYY')) /3) as Quarter