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')))

CODE

FLOOR((14 + DATEDIFF( mydate, TRUNC(mydate,'YY') ) + DATEDIFF( TRUNC(mydate,'YY'), NEXT_DAY(TRUNC(mydate, 'YY'),'SU'))) /7)