search file date range without year ?

[anmac1789]

Hello everyone, How do I search for date modified date range without the year ? For example dm:11..03 (November to march of any year)

[NotNull]

For any year:

Code: Select all

dm-month:march..november

For the current year (2023):

Code: Select all

dm:march..november

[anmac1789]

For any year:

Code: Select all

dm-month:march..november

For the current year (2023):

Code: Select all

dm:march..november

What if I wanted to search for month and day without year ?

[NotNull]

Take a look at the Search Functions and you will find the dm-day function and similar, including examples.

[void]

Would the following be helpful:

dm-month:march..november dm-day:14..21



or do you need a specific date on March to a specific date in November?
-I don't have an easy way to do this.
You'll have to setup a "datevalue" and then search that.

For example:

14th of March until the 21st November:

addcolumn:a a:=DAY($dm:)+(MONTH($dm:)*32) $a:>=14+(3*32) $a:<=21+(11*32)

where:
14 is the first day.
3 is the first month.
21 is the last day.
11 is the last month.

[anmac1789]

Would the following be helpful:

dm-month:march..november dm-day:14..21



or do you need a specific date on March to a specific date in November?
-I don't have an easy way to do this.
You'll have to setup a "datevalue" and then search that.

For example:

14th of March until the 21st November:

addcolumn:a a:=DAY($dm:)+(MONTH($dm:)*32) $a:>=14+(3*32) $a:<=21+(11*32)

where:
14 is the first day.
3 is the first month.
21 is the last day.
11 is the last month.

Basically, I'm looking to search DST months every year in EDT/EST timezones
1. Winter timezones - first sunday in november to 2nd sunday in march next following year
2. summer timezones - second sunday in march to first sunday in november of the same year

[void]

The following might be easier:

FORMATFILETIME($dm:)==FORMATFILETIMEUTC($dm:+(10.5*36000000000))

where 10.5 is your day light savings UTC offset.

This will list files modified during day light savings.

Use != to invert the results.

[anmac1789]

The following might be easier:

FORMATFILETIME($dm:)==FORMATFILETIMEUTC($dm:+(10.5*36000000000))

where 10.5 is your day light savings UTC offset.

This will list files modified during day light savings.

Use != to invert the results.

How does this work because for DST, it depends on EST/EDT,

EST: First Sunday in November to second Sunday in March
EDT: Second Sunday in March to first Sunday in November

[void]

This just matches files where the date modified in local time is the same as the date modified in UTC + some offset (10.5 hours in this case).

Date modified is stored in Everything in UTC.
UTC doesn't have daylight savings.
Converting to local time will apply any daylight saving offsets.
The system does this conversion (not Everything).

FORMATFILETIME() will apply daylight saving offsets.
FORMATFILETIMEUTC() does not apply daylight saving offsets.

Adjust the +10.5 hours to match the desired daylight saving offset.