date = Today () returns nothing. (
Hello!
I got a date field.
I created a formula column in that table to filter records with the date of today with a simple formula:
date = Today ()
But it returns nothing. But when i change it to:
date > Today ()
then it shows the records from today and the future!
Cant figure out where is the error.
Any help very much appreciated, guys!
Thanks,
Agassi
5 replies
-
@Agassi
What is the data type of your "date" field? What platform are you on?
-
UPDATE
I narrowed the problem a bit.
In that table besides this date field i have an Appointment field, that i actually use. And the mentioned date field is filled with a value of the appointment field with "Trigger after update" in the Appointment field setings via
'Date field' := date('Appointment field') formula.So, when in one record i deleted the value of the date field and then manually selected today's date in it, that record showed up in the filtered list.
So, somehow the value that is writen by the formula 'Date field' := date('Appointment field') is not ok for the system.
I guess i need to modify the formula to update the date field from the appointment field.
Or maybe you can give me a formula with which i can filter the list using directly the appointment field!!
Thanks
Agassi
-
@Mconneen
its a date field.
Im on a web version. I wrote an update, please check it, maybe it will explain something. Thanks!
-
@Agassi,
The "magic" is in the statement about it being set from an Appointment. Not 100% sure what date('Appointment field') will yield.. as there is a start and an end.. which can span dates. This works.
date(start(Appointment)) = today()
-
@Mconneen
Thank you very much!
It works like a charm!
Content aside
- 3 yrs agoLast active
- 5Replies
- 756Views