2 Replies Latest reply on Dec 9, 2010 8:00 AM by darth pathos

    DateTime field calculation

    darth pathos

         Wow, second thread and it's only my first day!

       

      I have a DateTime field that I'm trying to have validated so that the user cannot pick a date before today.  I know how to do it in Crystal Reports, Visual Basic, and a pile of other languages - but this one I'm stumped.

       

      Here's all I've got.  Logic is very simple, but I'll be darned if I can get this to work!

       

      if

       

      (date2num(datetimefield1) - date2num(date()))<0 then messageBox("Test", "Wrong Date", 1, 0) elseif datetimefield1 endif

       

      Thanks - any and all ideas are appreciated!

      Chris