Skip to main content
Skip table of contents

Other functions

The following functions do not exist within indexima. However, you achieve your goal by applying the following formulas.

Weekday

CODE
(8 + DATEDIFF(mydate,NEXT_DAY(CAST(mydate AS DATE),'SU')))

WeekNumber

CODE
FLOOR((14 + DATEDIFF( mydate, TRUNC(mydate,'YY') ) + DATEDIFF( TRUNC(mydate,'YY'), NEXT_DAY(TRUNC(mydate, 'YY'),'SU'))) /7)
JavaScript errors detected

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

If this problem persists, please contact our support.