Topics started by ddilauro_bp

1 Topic

D
Do Gooder (Customer)
ddilauro_bpDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

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.10We 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

1
T
Hero (Employee)
1 month ago

Badges

Show all badges
Terms & ConditionsCookie settings