Skip to main content
Skip table of contents

Converting a date to its associated week number

This page is for MYOB Advanced consultants

Check all changes in a test environment before taking them live. Make sure all related features still work as expected and that your data is unaffected.

The following logic can be used in the report designer to convert a date into the week number it is asscoiated to, for example 1st June belongs to week 22 whereas the 1st January belongs to week 1.

The example below is taking the TranDate field from the table INKitRegister

=Ceiling(DayOfYear( [INKitRegister.TranDate])/7.0)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.