SQL Date in Table Transformer

[Leona]

Hi,

A simple SQL in Table Transformer, but nothing is returned.

SELECT T1.'Status', T1.'Due'
FROM T1
WHERE T1.'Resolution' = "Unresolved"
AND T1.'Due' > 2022-05-30

Macro Settings Date format is set to yy-mm-dd (see screenshot)

What am I missing? Thanks.

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Leona ,

Try to use double quotes for your date:

SELECT T1.'Due', T1.'Resolution'
FROM T1
WHERE T1.'Resolution' = "Unresolved"
AND T1.'Due' > "2022-05-30"

Hope this helps.

[Leona]

Hi @Katerina Kovriga _Stiltsoft_ 

Thank you for replying. With the code below, I receive

SELECT T1.'Status', T1.'Due'
FROM T1
WHERE T1.'Resolution' = "Unresolved"
AND T1.'Due' > "2022-05-30"
ORDER BY T1.'Due' DESC

Something weird, for setting with yy-mm-dd, no results. All other date settings, I get result but wrong.

[Katerina Kovriga _Stiltsoft_]

The date format should correspond the format that you have in your table and in your query (see my example).

I have "yy-mm-dd" format in three places:

• the Table Transformer macro settings
• the "Due" column
• the date for comparison that is "2022-05-30"

For your case, as your dates come from Jira, choose the "M dd, yy" in the Table Transformer macro and change the date for comparison as "May 30, 2022".

Then everything should work correctly.

[Leona]

@Katerina Kovriga _Stiltsoft_ I changed the setting to "M dd, yy" and it works!!! Thank you so much!