@Mark Shnier (YQC) and
@Don Larson thank you both for reply. I tested it and indeed it works in 99 % of a time.
In my previous formulas it was not working for particular dates and it is also not working with your suggested formula.
When I dig further I found out that problem lays in date format. For my App I have Date format set as DD-MM-YYYY. And my assumption is that formula queries are using MM-DD-YYYY.
It started to work when I first use "ToText" on my date fields to Convert date to QB standard format from DDMMYYYY to MMDDYYYY.
In Formula Queries I used converted date field as you suggested, and it works :)
------------------------------
Adam Krzyzanek
------------------------------
