dc-day and other date and time derivatives with customn columns?

Discussion related to "Everything" 1.5.
anmac1789
Posts: 757
Joined: Mon Aug 24, 2020 1:16 pm

dc-day and other date and time derivatives with customn columns?

Post by anmac1789 »

There is a difference between dc-day: and dc-day:10

How do I use dc-day: without anything after the semicolon using a custom column ?
therube
Posts: 5848
Joined: Thu Sep 03, 2009 6:48 pm

Re: dc-day and other date and time derivatives with customn columns?

Post by therube »

Looks like dc-day: is essentially nul (the same as if you didn't enter 'dc-day' at all).
dc-day:10 will find files/directories created on the 10th day of any month, any year.
anmac1789
Posts: 757
Joined: Mon Aug 24, 2020 1:16 pm

Re: dc-day and other date and time derivatives with customn columns?

Post by anmac1789 »

How do I use it as column1:=dc-day: to retrieve each file and folder's day of the month ?
void
Developer
Posts: 20362
Joined: Fri Oct 16, 2009 11:31 pm

Re: dc-day and other date and time derivatives with customn columns?

Post by void »

Use the Excel DAY function.

For example:

add-column:a a:=DAY($date-created:)


DAY()



dc-day:
will match any file/folder with a date created.

dc-day:
anmac1789
Posts: 757
Joined: Mon Aug 24, 2020 1:16 pm

Re: dc-day and other date and time derivatives with customn columns?

Post by anmac1789 »

dc-day:
only produces
0:
void
Developer
Posts: 20362
Joined: Fri Oct 16, 2009 11:31 pm

Re: dc-day and other date and time derivatives with customn columns?

Post by void »

dc-day: is not a formula property.
Use DAY($date-created:) with formulas.
Use dc-day: with a normal search.