Calculated line for 'Today'

Question & Answer
, ,
1

I have created calculated custom reference lines for months on a bar chart utilizing a calculated field.
I’m struggling with the syntax formula for “Today”.

This is the successful one I used to represent November 2024;
dateDiff({Min_Date}, parseDate(‘11/01/2024’, ‘MM/dd/yyyy’))

I want to remove the specific November reference and just use now() so it shows today’s date dynamically, but getting errors. THX!

2

Hi @anneshie

Could you please try the following calculated field, you can replace the hardcoded date with the now() function in your formula.

**Example: **

dateDiff({Min_Date}, now())

Following Images from the sample data.

image

image

1 Like
3

Fantastic this works great thank you so much!