Extracting Todays day in a slice

[stayonpointtatt]

Hello,
I am trying to make a slice that only outputs rows that have an datetime of today’s day. Here what I put together

AND(DAY(TODAY()) = DAY([Appointment Date]), [User] = USEREMAIL())

For some reason its not working I’m sure it could be wrongly structured… Please any advice on how I can make this happen!

[Suvrutt_Gurjar]

It sounds that your expression is syntactically correct. It will return all the rows with [Appointment Date] for the logged in user based on TODAY() 's day of the month. So on 18th November 2020, the expression will return all rows with [Appointment Date] 's day of the month being 18 irrespective of year and month of [Appointment Date]

If you are looking to have only the appointments of 18th November 2020 on TODAY() being 18th November 2020, I believe your expression could be something like

AND(TODAY() = [Appointment Date], [User] = USEREMAIL())

The [User] column should also have the value of the logged in user.

Please post back if you are looking for something else.