Use the "NOW" function without including the time,

[ap1128]

Hello! I am trying to figure out how to use the “NOW” function without including the time, only the date. Alternatively, if someone could tell me how to add “Yesterday’s date” as a function, that would be helpful too.

Thanks in advance!

[Sakshi_agr12]

Hey @ap1128
Welcome to the Make Community

Try using this function , it will give you today’s date without the time and also i have added the function for yesterday’s date.

[alex.newpath]

The formatDate() functions returns a text string and that may not work in the filter part of the Notion search objects module. You may wish to apply parseDate() back on the formatDate() text string which will set the time to 00:00:00 because a proper date data type always is a timestamp with a time component.

so something like parseDate(formatDate(now,"DD/MM/YYYY"),"DD/MM/YYYY")