3 Replies Latest reply on Jul 13, 2011 11:57 AM by PeggiHall

    Current Date to use in a formula



      Current Date to use in a formula


      Can anyone tell me how to put the current date according to the computer clock in a layout and then use it in a calculation field. 

      I can insert the date symbol // but then there is no way to use that in the formula that says if Check in Date >1/1/2011 and Check out date is greater than todays date.  In the old Filemaker just used Today and it worked fine but this FMP 11 is all different.  Basically I just want a field that has the current date in it so I can calc different ways.

      Any help would be greatly appreciated.