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?
I suggest adding a Quarter field to your data model:
'Quarter ' & ceil(month(someDate)/3) as Quarter,
YOU MEAN THAT IF MY FIELD IS INV_IVDATE
I SHOULD wright it like this:
'Quater' &'- '&ceil(month(INV_IVDATE)/3 as quater ?
With a extra parenthesis at the end:
'Quater' &'- '& Ceil(Month(INV_IVDATE)/3)
Silly me; I overlooked that one . Sharp one, Sunny!
Yes; add that as field in the table during your reload .
Retrieving data ...