Referencing dates in IDM xQuery

Legacy Contributor

Hi All,

Is there any way to mimic functions like now(), today(), and getdate() within an IDM xQuery?

I'm looking to create an IDM homepage widget that pulls in documents created today or in the last X days, etc.

Thanks.

Legacy Contributor

You can use the date() function. Here are some examples:



/Document_Type[@CREATETS >= date()] //returns all documents created today

/Document_Type[@CREATETS < date(-60)] // returns documents that are 60 days or older