7 Replies Latest reply: Jul 18, 2014 5:41 AM by Herbert Chitate RSS

    Date Manipulation

      Good morning All,

       

      I am a bit shtumped and not quite sure where I am going wrong.

       

      In a text box on my app if I use the formula =Max(Date) I get 17.7.14. If I modify this to Num(Max(Date)), I get 41837, which tells me my dates are all ok.

       

      However on the script side of things, I am trying to create a variable vMinDate, using Let vMinDate=Num(Min(Date)). I get a script line error. ( In a previous load statement, I have "Date" field).

       

      I am not sure why, can anyone assist?

       

      Thanks