Page Designer Date Comparison to Control Visibility

Has anyone had success in using date arithmetic to control visibility of page elements through Page Designer?

Cloud - 23.1.10

We can see value, for example, in not allowing  ‘Closed’ shop orders to be re-opened after a certain amount of time - say 1 year. In Page Designer on the Manufacturing > Shop Order > Order > Shop Orders page, I can use a hard coded comparison date on the Shop Orders Open command, Visible condition as such: record.CloseDate >= ‘2023-03-14’ to limit the appearance of the button to only orders closed within the last year. However, I’ve not been able to come up with a way to use a dynamically generated “year ago” date to compare.

The variables understood by the page search function don’t stand up to a syntax check. [ #TODAY# -1Y]

System and DB functions like these fail as well:

• sysdate
• to_date()
• date()

Thanks,

Dan