# Now() function not working

**URL:** <https://community.holistics.io/t/now-function-not-working/1935>\
**Category:** Ask the Community\
**Tags:** date-time\
**Created:** [May 9, 2024, 10:26am UTC](https://community.holistics.io/t/now-function-not-working/1935 "2024-05-09T10:26:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grant\_Orchard](https://community.holistics.io/user_avatar/community.holistics.io/grant_orchard/32/1246_2.png) [@Grant\_Orchard](https://community.holistics.io/u/Grant_Orchard)\
**Post date:** [May 9, 2024, 10:26am UTC](https://community.holistics.io/t/now-function-not-working/1935/1 "2024-05-09T10:26:11Z")

</div>

Hey Team - I am trying to add a date field using the now() in the calculated fields. I was wondering if this can be done. I am looking to add a todays date field in pivot table format: Is there a way to add a date field that is not part of the source table?

 ![Screenshot 2024-05-09 at 11.24.39](https://community.holistics.io/uploads/default/original/2X/4/411b4016f9664e2f0ed770e550d055d4fd07ed83.png)  
 ![Screenshot 2024-05-09 at 11.24.08](https://community.holistics.io/uploads/default/original/2X/4/4b3913a254ff153e8c7d52707c82a10cb699dc73.png)

---

<div class="post-metadata">

**Author:** ![kaid](https://community.holistics.io/user_avatar/community.holistics.io/kaid/32/12_2.png) [@kaid](https://community.holistics.io/u/kaid)\
**Post date:** [May 9, 2024, 10:55am UTC](https://community.holistics.io/t/now-function-not-working/1935/2 "2024-05-09T10:55:41Z")

</div>

Hi @Grant_Orchard, looks like you are adding a legacy [Business Calculation](https://docs.holistics.io/docs/business-calculation) formula.

The `now` function is an AQL function and should be added by adding an AQL dimension/measure instead. We will deprecate the Business Calculation function soon to avoid the confusion.

---

<div class="post-metadata">

**Author:** ![Grant\_Orchard](https://community.holistics.io/user_avatar/community.holistics.io/grant_orchard/32/1246_2.png) [@Grant\_Orchard](https://community.holistics.io/u/Grant_Orchard)\
**Post date:** [May 9, 2024, 11:49am UTC](https://community.holistics.io/t/now-function-not-working/1935/3 "2024-05-09T11:49:45Z")

</div>

hhmmm okay

We haven’t started using AQL engine yet.

---

<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:** [May 9, 2024, 1:52pm UTC](https://community.holistics.io/t/now-function-not-working/1935/4 "2024-05-09T13:52:16Z")

</div>

> [@Grant\_Orchard](#):
>
> We haven’t started using AQL engine yet.

Hi @Grant_Orchard, could you share any challenges you’ve been facing when moving from Business Calculation to AQL Expressions? 🤔