Date Tags

Date tags are placeholders for different date operations relative to when a query is run. Date tags make date fields easier to work with by saving you from having to perform calculations with the MongoDB Date() function.

Studio 3T converts the date tags when the query is run into the appropriate MongoDB query, using greater than and less than operators to cover the calculated time range.

For example, in the screenshot above, the query

{ "registered_on": #today }

expands into

 "registered_on" : { 
            "$gte" : ISODate("2024-05-08T00:00:00.000+0000"), 
            "$lt" : ISODate("2024-05-09T00:00:00.000+0000")
        }
    }

and the range is automatically updated when that query is run, to reflect the time and date of that run.

Where can Date tags be used?

You can use Date tags in the Collection tab’s Query bar, IntelliShell, Visual Query Builder, in the Aggregation editor when creating a $match stage, and in Find and aggregation queries used in Exports.

Relative Date Tags