Date Diff calculation with AQL

Ask the Community
1

Hello - I’m looking to replicate calculating a date diff using a cross model aql dimension. Is this possible? What i’ve tried is converting to epoch in seconds then subtracting and dividing by desired timeframe. This isn’t always exact as doing a datediff function in snowflake. Curious if there is a way to do this or if i’d have to create a query model.

Thanks!
Nick

1 Like
2

Hi @nicholashernandezjlo,

We do support date_diff() function in AQL.
You can refer to our Community Post here for more information https://community.holistics.io/t/upcoming-our-brand-new-analytics-query-language-aql/1533/18.

Please let me know if you need further support :smile:

1 Like
3

Man not sure why i couldn’t find that function here but works for me - thank you!

1 Like