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?