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
