2 Replies Latest reply: Apr 17, 2012 3:48 AM by Anne Duffy RSS

    Weekday calc

      Hi Guys,

       

      I am looking to create a flag in my script that identifies when the date field is equal to "Yesterday"

      This is working fine except when its a Monday as Yesterday is then Sunday , ( I wish to identify Friday then !!)

       

      I need to amend the script to a weekday function , but have tried a few different things and cant quite get it , can anyone help

       

      This is formula as it is now :

       

      If(Period_dte = Today() - 1, 'Yes',null()) as YesterdayWH,

       

       

      Can anyone help ?

       

      Thanks


      A