2 Replies Latest reply: May 19, 2014 9:23 AM by Anand Chouhan RSS

    If Statement in Script

    Isabel Nowinowski

      Hi,

           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.

       

      Kind Regards,

      Isabel