Time-restraint Task-DV neglects month

[Gewerd-Strauss]

Hello,

I just noticed this by chance, and I am a bit confused as to why this happens. I have a task-DV that only shows tasks due in the coming 3 days, including today.

``` dataview
task 
where dateformat(date(today),"dd.MM.yyyy")  <= due & dateformat(date(today)+dur(2 days),"dd.MM.yyyy")>=due & start<=dateformat(date(today),"dd.MM.yyyy")

group by file.name
```

So far, this has worked nicely, but by pure chance I now notied the following:

Above you can see some mock tasks being set up. Intended is for only Test2-4 to show. However, after a bit of testing it seems that any date is considered if its day-component falls into the number-range of (today--today+2), and as long as the month-component is greater than or equal to the current month's value. The year-value is apparently unused and doesn't seem to contribute to filtering. All in all this seems extremely weird, which leads me to assume I am querying this falsely before I'm filing a bug-report, instead of afterwards.

[blacksmithgu]

You don't need any of the dateformat calls - they are formatting the dates as plain text, which is then being compared alphabetically which is producing this wierd result. Just do date(today) <= due, and so on.

[AB1908]

That's because date() can't really parse your dates because they're not in ISO format.

[Gewerd-Strauss]

Is there a way of converting it automatically, internally (aka is there a function implemented which can convert dates into various formats such as ISO), or am I out of luck for using ddMMyyyy-formatted dates? Could such be implemented? While I use ISO8601 frequently in my own projects for sorting purposes, I really dislike it for displayed dates.

[AB1908]

There isn't one ATM. You can get around it by constructing it for yourself, date(join(reverse(due.split(".")), "-")) but it's certainly not pretty.

[AB1908]

If you switch to DVJS however, you have access to moment() or Luxon to work with.

[mnvwvnm]

About the "displayed format" you can define it (with dateformat()) or in settings>Dataview.
One thing is the inputted format, other thing is the rendered format.