This content has been marked as final. Show 2 replies
I have a variable 'vCurrentWeekStart' that gives me the start of the current week (Thursdays). It gives me the correct date on any day except for Thursday. On Thursday's, the variable gives me the start date for the previous week not the date of the current Thursday. I was wondering if it were possible to write an if statement in the script that would add 7 days to the vCurrentWeekStart on a Thursday.
if(WeekDay(Today()='Thu', vCurrentWeekStart=vCurrentWeekStart+7, vCurrentWeekStart)
This does not work and I was wondering if there was another way to get a similar result.