Date issue

Ramu_kd54ib

Hey ..

Im using a Table Transformation and trying to segregate/categorise my EPICs Quarterly wise .. My Table have the EPICs with Target End dates captured ..

 

My need is as follows:

CASE
WHEN T1.'Target end'>= 2023-10-01 AND T1.'Target end' <= 2023-12-31 THEN "Q1"
WHEN T1.'Target end'>= 2024-01-01 AND T1.'Target end' <= 2024-03-31 THEN "Q2"
WHEN T1.'Target end'>= 2024-04-01 AND T1.'Target end' <= 2024-06-30 THEN "Q3"
WHEN T1.'Target end'>= 2024-07-01 AND T1.'Target end' <= 2024-09-30 THEN "Q4"
END AS 'Target End',

 

But .. it is not returning the expected output(Q1,2,3 or 4) .. in the resultant Table .. it simply returns the blank column as follows:

 

 

(Tried combn: of placing the dates inside single/double quotes .. still of no use) ..

 

Please suggest/help me to capture the aforementioned Date range in the Table Transformation .. and get the result ..

 

Stiltsoft support

Hi @Ramu ,

As I see, you use the Table Transformer macro that is provided by the Table Filter, Charts & Spreadsheets for Confluence app.

So, if you have a specific question regarding the app, it is better to refer to our support. Here we find relevant questions manually and can easily miss something. Besides, as the support portal is confidential, you'll be able to share your page storage format and the screenshot of your source Jira table for us to look closely.

As for now, the variant of your query with the double quotes works for me fine:

SELECT
CASE
WHEN T1.'Target end'>= "2023-10-01" AND T1.'Target end' <= "2023-12-31" THEN "Q1"
WHEN T1.'Target end'>= "2024-01-01" AND T1.'Target end' <= "2024-03-31" THEN "Q2"
WHEN T1.'Target end'>= "2024-04-01" AND T1.'Target end' <= "2024-06-30" THEN "Q3"
WHEN T1.'Target end'>= "2024-07-01" AND T1.'Target end' <= "2024-09-30" THEN "Q4"
END AS 'Target End'
FROM T*

You may check if the dates coming from your source table match the date format that is used within your SQL query.