Dates being read as text

Kelsey Lubbe

Hi all, 

I need to be able to sort by a date field "Escalation Date." That field is being read as text. I've tried adjusting formatting in my Excel file and in multiple places in the Confluence page and no luck. 

Steps to get data into this page

1. Data is exported to a CSV file. I opened the CSV as a text filed and dates are all displayed as m/d/yy, eg, 11/1/22 and 3/4/21.
2. CSV file is uploaded to Confluence. 
3. This page uses 'Table from CSV' macro to pull in that data. My Data Format selected is Wiki markup. I'm using this since I have a few columns where width is defined in my CSV. 
4. 'Table from CSV' is in a 'Table Transformer' macro where I have a SQL query to define needed columns. This is essentially a simple SELECT 'Escalation Date' FROM T*. The date format selected is m/d/y, which I believe matches the data in the CSV (see #1) 
5. This is wrapped in "Table Filter" macro.

Katerina Kovriga {Stiltsoft}

Hi @Kelsey Lubbe ,

I've recreated your case and the sorting works for me just fine:

SELECT T1.'date'
FROM T*
ORDER BY 'date' DESC

Here I already sort my column:

And here I use the Table Filter macro on top to sort it backwards:

The date format that you use is correct.

From the first screenshot I see that your macros have more complex SQL queries: CASE WHEN... Maybe at some point you modify the date or smth.

So please create a support request here tech-support@stiltsoft.com where you attach the Page Storage Format (upper right corner of the page -> menu ... -> View Storage Format) and the source CSV attachment.

We will recreate your page and look into the issue.

Besides check if you use the up-to-date version of the app - the current one is 8.0.0.