Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
'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,
Hi PM,
Thank you for your help.
No error msg , but does not display value.
Paul
or you can try like this
'Q' & ceil(Month(Date#([Opportunities Expected Close Date],'DD/MM/YYYY')),3)/3 as [NewQuarter],
Take [Opportunities Expected Close Date] field as list box and share screen shot...
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
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
PM
Still Can not.
Paul
Please share screen shot like below
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