How to get DateTimeDiff using In-Database tool

[Oskido]

Hi,

I would like to get number of days between two dates using In-Database tool.

Is it possible?

Thanks..

[DataNath · Accepted solution]

@Oskido when using the In-DB tools and the Formula In-DB tool, you need to use the SQL syntax of the platform you're connecting to. For example, if you're connecting to Snowflake it'd be:

DATEDIFF( day, <date1>, <date2> )

[Oskido]

Thank you. I am connected to SQL database..

[Oskido]

It worked. Thank you...