Now() function not working

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?

Hi @Grant_Orchard, looks like you are adding a legacy 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.

hhmmm okay

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? :thinking: