Today's Filter

[ModernAchilles]

Hi,

I need help getting this sales data filtered for Today. I am able to get the last few days and even time periods after that, but I cant capture today's sales. 

Here is my formula that works between dates:

I need hlpe on this one to capture today's sales only.

Thanks so much!!

[v-chuncz-msft · Accepted solution]

@ModernAchilles,

You may use expression below.

[Custom Date Time] >= TODAY ()
    && [Custom Date Time]
        < TODAY () + 1

[nirvana_moksh]

@ModernAchilles - Today() returns Date Time, is your custom date time the same format?