I am getting Extra value in Quarter data - Q.
Using the below formula in script.
'Q'&ceil(month(date(HireDate))/3) as Quarter.
I am using SET DateFormat='DD-MMM-YYYY'; in script.
Please help me.
If you have missing dates in the field then you will get like this, check why you are getting empty values in Date column, if the date value is mandatory then this will be the issue, also those records will not be available for selection.
Cross check the missing dates, if it is not a concern then you can use
If(Len(Trim(HireDate))>0,'Q' & Ceil(Month(HireDate)/3)) as Quarter
Hope this helps you.