Forum Discussion
ModernAchilles
7 years agoHelper I
Today's Filter
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!!
You may use expression below.
[Custom Date Time] >= TODAY () && [Custom Date Time] < TODAY () + 1
2 Replies
- nirvana_mokshImpactful Individual
ModernAchilles - Today() returns Date Time, is your custom date time the same format?
- v-chuncz-msftCommunity Support
You may use expression below.
[Custom Date Time] >= TODAY () && [Custom Date Time] < TODAY () + 1