Sorry, but this is not working correctly. Now I am not getting any error message but the data is not coming thru correctly.
This is the code I have used.....
Timestamp(DOB,'ÝYYY') as Year,
month(DOB/3) as Quater;
Date as DOB
[G:\Users\40100095\Audit Action Insights Dashboard\test date.xlsx]
(ooxml, embedded labels, table is Sheet1);
have to use ceil or dual function to get the quarter
something like ceil(month(dob)/3) as quarter or dual('q' & ceil(month(dob)/3), ceil(month(dob)/3)) as quarter
coming to the calculated fields, you cant use those in the same table. use resident load and use them
can you please share exactly what you trying to achieve here....