SQL to spotfire date expression question

[Anthony stark]

Hi Experts,

How do i write the sql date expression below in spotfire expression sysntax

(A.STARTDATE > TO_DATE('27-APR-20','dd-MON-yy')+999

OR A.STARTDATE

[Anthony stark]

Any help

[Stefan Hansen 2]

Hi, can you explain what you want to do here

 

Calculating new columns or just filtering the data

[Anthony stark]

I am trying to calculate a new column with the SQL syntax converted to a spotfire expresssion. Thanks

[Stefan Hansen 2]

The syntax you have pasted is not my area of expertise can you explain what it does, do you want to add or subtract a number of days from the date column

Please explain the data you have and what you want to do with it.

[Anthony stark]

Hi Stefan, im trying to calculate 999 calendar days before or after that date specified

[Stefan Hansen 2]

Thank you for explaining :)

You can use the dateadd function:

 

To calculate +999 days:

DateAdd('day',999,[DateColumn])

-999:

DateAdd('day',-999,[DateColumn])

 

In the Data> Calculated column, you can click on the category 'Date and Time' to see the functions that handles dates, if you click on an individual function you can see the syntax that you need to use it.

Hope this works for you.

[Anthony stark]

Thanks Stefan, i appreciate it