format date to weeknumber in pages RTC

mdPartnerNL
mdPartnerNL Member Posts: 802
edited 2014-03-07 in NAV Three Tier
to display the week number in the subform of the orderlines im using

source expression = FORMAT("Requested Delivery Date", 0, 'W<Week Year,2><Week,2>')

This result in the correct week number W1412

but when the "Requested Delivery Date" is 0D is displays W0001

In classic I could add code to the onafterformat trigger to display nothing but how in RTC. Any hint?

Comments

  • james_cs
    james_cs Member Posts: 39
    In RCT you will need to calculate the value you want to show OnAfterGetRecord, and pass the value as a variable up to the client. You can't execute code on the page because the page is on the client and the code is executed on the server.

    That is the way 3-tier architecture works. :)
  • mdPartnerNL
    mdPartnerNL Member Posts: 802
    But sometimes you must do some simple coding with data, bold on/off, colors, formatting.

    Onafterrecord trigger isn't fired while typing in a new record, fields.

Categories