Hello,
Can anybody help me in getting the name of the day for a date?
for eg. getDay(today()) then it should return "Tuesday".
Also, how can we calculate the week range if you pass weeknum(today())? here, week range means from date range for that particular week.
Thanks,
Omkar
Discussion posts and replies are publicly visible
You can get the name for day from date as -
index( split( text( ri!testDate, "mmm/dddd/yyyy" ), "/" ), 2, "" )
to get the range use the code below to get two dates
/*day 1 of the week - Monday*/ ri!testDate - weekday(ri!testDate,3) /*Last day of the week - Sunday*/ ri!testDate + 7 - weekday(ri!testDate,2)
you can change the numbers to get the desired day of the week (if not Monday - Sunday).