Function syntax is the same (Omniscope / Excel).
TODAY()
also available - NOW()
both useful to combine in formulas and insert either in date format or text, in combination with other functions, such as DATETOTEXT:


DATETOTEXT(NOW,
"dd/MM/yyyy hh:mm")

To explore other date functions please click on the "date" filter on this page:
https://omniscope.me/FunctionsWEB.iok/

Thanks Paola - is it possible to call this directly in a record filter? I hit an error when I try to set this up. Or do I have to set up a formula first?

You can create formulas in:
- DataManager's Field Organiser block (Create new field>use formula)
- DataExplorer's Table view Tools>Formulas>Add formula field
- Data>Manage fields >Add new field

You cannot enter "TODAY" in the [Date] field filter and expect it to return records with today's date.
Having said that... You could set up a new formula field with :

IF(
[Date]=TODAY,
"TODAY",
null)

Now you can :-)

Thanks again for your help Paola - I will test this now.