quater - date

[#1]

Hello,

I am trying to build a sales report,

I want to show the sales based on the first Quarter, second quarter and esc,

I have a date field how can I preform it?

[oknotsen]

I suggest adding a Quarter field to your data model:

'Quarter ' & ceil(month(someDate)/3) as Quarter,

[#3]

YOU MEAN THAT IF MY FIELD IS INV_IVDATE

I SHOULD wright it like this:

'Quater' &'- '&ceil(month(INV_IVDATE)/3 as quater ?

[sunny_talwar · Accepted solution]

With a extra parenthesis at the end:

'Quater' &'- '& Ceil(Month(INV_IVDATE)/3)

[oknotsen]

Yes; add that as field in the table during your reload .

[oknotsen]

Silly me; I overlooked that one . Sharp one, Sunny!

[sunny_talwar]

No problemo