Filter date without hour in Excel

Help StudioX
,
1

Hi, robot after entering the command below to filter the date and time, how to filter only the date?

A filter setting window is shown with the Advanced filter option selected and configured to filter for a date equal to "now.AddDays(-1)." (Captioned by AI)
A filter setting window is shown with the Advanced filter option selected and configured to filter for a date equal to "now.AddDays(-1)." (Captioned by AI)742×525 8.92 KB

2

Hi @sullivanne

Try that. Datetime.now.AddDays(1)

3

@sullivanne

If looking to compare day to day from two datetime datatypes try like this.

date1.Date = date2.AddDays(-1).Date
1 Like