Hi How can I default a date field to the first of the current month and year? Thanks Regards
J John Jun 9, 2007 #1 Hi How can I default a date field to the first of the current month and year? Thanks Regards
W Wayne-I-M Jun 9, 2007 #2 Hi John Use for year =DateSerial(Year(Date())+0,1,1) For month =DateSerial(Year(Date()),Month(Date()),1) Hope this helps
Hi John Use for year =DateSerial(Year(Date())+0,1,1) For month =DateSerial(Year(Date()),Month(Date()),1) Hope this helps