Hi Richard - At 12.49 I would like to be able to set the default value to the 20th of the month following, which is standard terms of trade in New Zealand.  Can you please tell me how I would write that in the Default Value Field.

---

Reply from Alex Hedley:

Check out Expert 27 and Expert 28
These cover Date/Time Functions.

You could use the DateAdd Function
DateAdd ( interval, number, date )

DateAdd ("m", 1, #20/07/2015#)
Result: '20/08/2015'

If you need to get the Current Date and use that you could do the following:

You could use DateSerial to build up the date
=DateSerial(Year(Now()), Month(Now())+1, 20)