Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Adding days to date for In-DB

Highlighted
Asteroid

Hi,

 

I'm connected to a SQL database via in-DB and have a date field which I would like to add and subtract 30 days to. I know there is the syntax DateTimeAdd, however this doesn't work in-DB.

 

Does anyone know how this can be done using In-DB?

 

UPDATE: I've realised that the syntax for SQL is DATEADD

 

Thanks

afk

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @akasubi 

 

Yes, just to clarify, In-DB functions and formula tool are dependent on the database SQL syntax. 

 

Cheers,

Labels