How to write current time comparing domain for xml

athelia · January 5, 2021, 6:29am

Hi,

I have some records, for example:

Venue, Start date, End date
Meeting Room A, 5/1/2021 10:00:00, 5/1/2021 12:00:00
Meeting Room B, 5/1/2021 11:00:00, 5/1/2021 12:00:00

If current time is 5/1/2021 10:30:00, I want to display only Meeting Room A in the tree view.

Something like this
<field name="domain" eval="[(*current_datetime*, '<', 'end_date' )]" pyson="1"/>

May I know how to write the current_datetime in XML domain for this case? Thank you.

ced · January 5, 2021, 9:19am

You must use a PYSON expression with DateTime like: [('end_date', '>=', DateTime())].

athelia · January 5, 2021, 9:41am

Thank you, it works

system · February 4, 2021, 9:41am

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.