cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ModernAchilles Regular Visitor
Regular Visitor

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:3 weeks sales.PNG

 

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

 

Today Sales.PNG

 

 

 

Thanks so much!!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Today's Filter

@ModernAchilles,

 

You may use expression below.

[Custom Date Time] >= TODAY ()
    && [Custom Date Time]
        < TODAY () + 1
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
nirvana_moksh Established Member
Established Member

Re: Today's Filter

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

Community Support Team
Community Support Team

Re: Today's Filter

@ModernAchilles,

 

You may use expression below.

[Custom Date Time] >= TODAY ()
    && [Custom Date Time]
        < TODAY () + 1
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.