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 ?