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

    DateTime field calculation

    darth pathos Level 1

         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!




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


      Thanks - any and all ideas are appreciated!