can i modify a null with today's date

[Juan Vaca]

I have this situation where a value is still ongoing, so they leave it blank on the closing date.

Is there a way I can temporarily replace the blank (or null) with today's date upon opening the dashboard So when the data is updated, it's not affected.

I was thinking of calculating something like:

'null eq today'

I am trying to avoid the user to enter today's date to prevent any errors, am I on the right path

[Aditya Singh 3]

You can try the below condition, this will replace the null vaues with current date.

If([closing date] is null,Date(DateTimeNow()),[closing date])