# \[🚀 Launched\] Our brand new Analytics Query Language, AQL!

**URL:** <https://community.holistics.io/t/launched-our-brand-new-analytics-query-language-aql/1533>\
**Category:** Product Releases\
**Tags:** aml\
**Created:** [June 1, 2023, 8:14am UTC](https://community.holistics.io/t/launched-our-brand-new-analytics-query-language-aql/1533 "2023-06-01T08:14:10Z")\
**Posts on this page:** 1\
**Showing post:** 18

<div class="post-metadata">

**Author:** ![Khai\_To](https://community.holistics.io/user_avatar/community.holistics.io/khai_to/32/128_2.png) [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Post date:** [December 26, 2023, 6:32am UTC](https://community.holistics.io/t/launched-our-brand-new-analytics-query-language-aql/1533/18 "2023-12-26T06:32:54Z")

</div>

## 🚀 AQL has officially supported date\_diff function

We’re glad to announce that we have supported a more convenient way for you all to find the duration between 2 date fields.

Let’s imagine you’re working for an ecommerce company and you want to find out How long a user hasn’t placed an order, you would need to subtract 2 dates (Current Time and the Last time that Customer made the Order).

[https://cdn.holistics.io/community/amql/aql\_demo\_date\_diff.mp4](https://cdn.holistics.io/community/amql/aql_demo_date_diff.mp4)

You just need to simply use the `date_diff()` function for that types of calculation

```ts
date_diff('day', max(orders.created_at), @(now))

```

With this function, you can find the duration between any 2 date fields

```ts
date_diff(<Interval>, <Date 1>, <Date 2>)

```

Feel free to reach out if you have any questions.

---

_[View the full topic](https://community.holistics.io/t/launched-our-brand-new-analytics-query-language-aql/1533)._