Table Transformer: SQL Query for adding dates is retrieving blank values

[Vineet.Kotian]

Hi Team,

I am trying to add a calculated field name 'LTS End Date" which takes "Release Date" and adds 18 months to it and shows the new date in "LTS End Date" column. Maybe I am doing something wrong with the query as I am getting blank values (Preview image). 

Let me know if I need to share more details other than what I have already shared. Any help to fix this issue will be appreciated.

[Stiltsoft support]

Hi @Vineet.Kotian ,

The Table Transformer macro belongs to our Table Filter, Charts & Spreadsheets for Confluence app, so in case of any further questions, please refer to our support portal directly.

Meanwhile, you may go to the Screenshot 2 and set your date format as M dd, yy (this format is used in your source table and you also want to keep it).

Then you may visit our documentation and check the syntax for the DATEADD function (the macro is based on the AlaSQL library):

FORMATDATE(DATEADD(month, 18, 'Column Name'))

[WirkKael]

It seems like you're facing an issue where your SQL query for calculating and adding 18 months to the "Release Date" is returning blank values. It's likely that the SQL query might be missing the correct date manipulation syntax or there could be issues with the date format being used.

One thing you could try is to ensure that you're using the correct SQL function for date manipulation. For example, in MySQL, you could use:

SELECT DATE_ADD(`Release Date`, INTERVAL 18 MONTH) AS `LTS End Date`

Or if you're using a different SQL database (like SQL Server or PostgreSQL), the syntax for adding months may vary. For SQL Server, you would use:

SELECT DATEADD(MONTH, 18, [Release Date]) AS [LTS End Date]

Make sure that the "Release Date" column is in the correct date format and doesn't contain null or invalid date values. If the issue persists, feel free to provide more details about the error message or specific database you're working with for further troubleshooting.