TM1 GET WEEK DAY NAME

dn = dim_target;
## week days
sWeekdays = 'SunMonTueWedThuFriSat';

## week day:  0 = Sunday, 1 = Monday, ..., 6 = Saturday
nWeekday = MOD( DayNo( TODAY )  + 21915, 7);

## day name lookup
sDayName = Subst(sWeekdays,nWeekday*3+1,3);

Leave a comment

Design a site like this with WordPress.com
Get started