Forum: VirtualDJ Technical Support

There is no doc about dates in VDJ
Dates are in standard japanese date format : YYYY/MM/DD
Standard comparison operators are working : =, !=, <, <=, >, >= as well as text ones : is, is not, equal, not equal, contains, doesn't contain
and some extra verbs can be used as well such as : range, days since, start with, ends with ...

Usable dates are absolute : file date, first seen, first play
or relative days since first seen, days since first play, days since last play

this said, today is "days since xxx < 1"
range is a grouping command : days since xxx range 30
intervals can be specified as usual usingoperators > >= < <=

Very Basic doc is here:
https://www.virtualdj.com/wiki/FILTER%20FOLDERS.html

the link at bottom is broken : http://www.virtualdj.com/manuals/virtualdj8/interface/database/folders/filterfolders.html
and should replace with : http://www.virtualdj.com/manuals/virtualdj/interface/database/smartfolders.html#filter

annoying bug: when naming a filter folder, the click is pass through the dialog box and underlaying window is selected becomming attached to cursor and movable

I can't get it to work

Perhaps if you gave us some more detailed information about what you need and what you've tried....?

So far all you've said is that you need "a ranger of dates" (park ranger? lone ranger?) and "today's date or a date less that or greater than" (which doesn't make a lot of sense).

Having a date greater than today would mean you want to list files from the future. How are you expecting that to work?

information about what you need and what you've tried

what i need is

OK.....and what you tried is?

Look at the examples given, especially the last one (group by artist) that uses the full date. Notice how it's different to yours.

No need to try further. There was indeed an issue with dates using File Date field. Devs are looking at as we speak and a fix will be provided in future update.

thank you i had a feeling this was a bug

@Mastermc789 thank you for providing enough information to enable Atomix to investigate and discover the issue.

Note that since the 'File Date' column requires checking the date of every file in your database, it might be relatively slow to use even when it's fixed.
So if possible for your use, first seen would make the filter folder fill much faster.

If you have more of those feelings, you should apply for Beta tester :)

Team will provide a fix soon, but in the meantime you can use ..

Group by First Seen range x

where x is in seconds, so 86400 (for per Day group) or 2592000 (for per month grouping)
First Seen can be replaced with any other Date field.