Convert date field to Q1 Q2...

[#1]

Hello,

First, thank you for your assistance in helping me with the below issue.

I used the script below in the Expression field to get the quarter name

QuarterName([Date Rqstd])

Then to get Q1, Q2, Q3, Q4. I changed the above script to the one below.

'Q' & Ceil(Month([Date Rqstd])/3)

But as you can see there is an extra value "Q".  I checked the field data and there are no nulls.  how do I get it to just show Q1, Q2, Q3, Q4 in the listbox? Again, thank you for your help!

[sunny_talwar]

May be try this:

If(Len(Trim([Date Rqstd])) > 0, 'Q' & Ceil(Month([Date Rqstd])/3)) as Quarter

[#3]

it is complaining "As Quarter" error Garbage

[sunny_talwar]

Can you share the script?

[pho3nix90]

The must be something that isn't a proper date. If you want a workaround then you will be adding overhead into the calculation, rather sort the calendar out first in the ETL process.

Try this and see if it works.

'Q' & Ceil(Month(Trim([Date Rqstd]))/3)

Also have a look when selecting Q, which dates it links to.

[#6]

Hi,

here is the script

If(Len(Trim([Date Rqstd])) > 0, 'Q' & Ceil(Month([Date Rqstd])/3)) as Quarter

error message: Garbage after expression: "as"

[#7]

it links to no date, as it is Gray

[sunny_talwar]

Did you miss a comma at the end?

If(Len(Trim([Date Rqstd])) > 0, 'Q' & Ceil(Month([Date Rqstd])/3)) as Quarter,

[#9]

No, I had the comma there.

[sunny_talwar]

Can you share the script for the whole table and a screenshot of the error you are getting?