nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Date in Table Transformer

Leona_y8vkcf

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.

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Leona ,

Try to use double quotes for your date:

Wed 15-1.png

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

Wed 15-2.png

Hope this helps.

All comments

Katerina Kovriga {Stiltsoft}

Hi @Leona ,

Try to use double quotes for your date:

Wed 15-1.png

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

Wed 15-2.png

Hope this helps.

Leona_y8vkcf

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_y8vkcf

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

table-transformer