Skip to main content

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. o #TODAY# -1Y]

System and DB functions like these fail as well:

  • sysdate
  • to_date()
  • date()

Thanks,

Dan

Hi Dan, 

Unfortunately, the type of date-time support functions you are asking for is currently not supported in the client (layout attribute conditions). We are discussing extending this functionality within current development, but for now, you are restricted to static value comparisons.

 

Kind regards

Tobias 

Reply


Terms & ConditionsCookie settings