Hi~
I have created a form that will be used on the first week every month, the data entered is based on the previous month. I have currently set the date field to default to
=Format(Now(),"mm/""01""/yy") what I would like the field to do is to give me the previous month as "04/01/04". Hope this makes sense. Thanks in advance for your help. CC
I have created a form that will be used on the first week every month, the data entered is based on the previous month. I have currently set the date field to default to
=Format(Now(),"mm/""01""/yy") what I would like the field to do is to give me the previous month as "04/01/04". Hope this makes sense. Thanks in advance for your help. CC