Show today data within start date and end date column

[JaysonTatum]

Hi, need help
I just need a slice formula to get today’s activity within start date and end date. Thank you

[Suvrutt_Gurjar]

Welcome to the AppSheet community!

You could try the following slice filter expression.

AND([Start Date of Activity]=TODAY(), [End Date of Activity]=TODAY())

However, since you are dealing with both date and time in your requirement, you could evaluate using DATETIME type column instead of separate columns for Date and Time.

help.appsheet.com

Column Types: Diving Deeper

Learn more about each column type you can have when structuring your columns.

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

[JaysonTatum]

It didn’t work. I need to get the data row if the date today is between Start Date of Activity and End date of Activity.

[Suvrutt_Gurjar · Accepted solution]

The expression syntactically and as per requirement seems to be correct. Are there corresponding records available in the table that have both start date and end date as today?

Could you check in test pane of the slice filter expression by tapping on “Test” option?

Or please try an expression something like below
Please try AND([Start Date of Activity]<=TODAY(), [End Date of Activity]>=TODAY())

JaysonTatum:

I need to get the data row if the date today is between Start Date of Activity and End date of Activity.

Or please describe the above with some examples of date and time.

[Suvrutt_Gurjar]

Suvrutt_Gurjar:

JaysonTatum:

I need to get the data row if the date today is between Start Date of Activity and End date of Activity.

Or please describe the above with some examples of date and time.

Could you please do the needful as above?

Or try the below

Please try AND([Start Date of Activity]<=TODAY(), [End Date of Activity]>=TODAY())

[JaysonTatum]

Heres the source

[JaysonTatum]

Suvrutt_Gurjar:

AND([Start Date of Activity]<=TODAY(), [End Date of Activity]>=TODAY())

It’s working now Thanks, I thought this were the same formula. I didn’t see the “>” and “<” on your last reply
AND([Start Date of Activity]=TODAY(), [End Date of Activity]=TODAY())
AND([Start Date of Activity]<=TODAY(), [End Date of Activity]>=TODAY())