2 Replies Latest reply on Jul 19, 2013 7:10 AM by Kirk_1

    Set Field does not evaluate correctly

    Kirk_1

      Title

      Set Field does not evaluate correctly

      Post

           Set Varable [$postedDate: value:

           Let ( [
               ~dt = Get ( CurrentDate ) ;                                           // This is just to shorten the date calc
               ~dow = DayOfWeek ( Get ( CurrentDate ) ) ;              // This is the day number of the date
               ~delay = 3 ];                                                                 // The number of days back you want
            
               ~dt -                                                                            // Start with today
               ( ~delay +                                                                  // Subtract delay plus...
                   Case ( ~dow < 5 ; 2 )                                // plus 2 if the result would be a weekend day
               )                                              // End calculation of amount to subtract
           )                                                                                              // End Let
            

           This correctly evaluates to 7/16/2013... so $PostedDate = 7/16/2013

            

           Why doesn't this evaluate correctly? Set Field [Invoice::INPostedDate; "2/01/2013...$PostedDate"]