However could you please explain a bit more the syntax for using these fields in the query? How do I have to write a date DD/MM/YYYY, MM/DD/YYYY or other?
Moreover could you please indicate if there is some function to get the current date, like DateSys() or maybe simply Date()
Ah, sorry. Try here