Date Picker Default Value 1

[PWD]

Good afternoon. I am trying to replicate a form field that was in a database in my previous job where there was a Date Picker but the default value was the start of the previous month.

Reading a previous post on here I have formatted the text box as Short Date.

I have attempted to start by adding something to the 'Default Value' - =Day(Date()) but it still just displayes today's full Short Date.

Any help will be gratefully received.

Many thanks,
D€$

 

[fdcusa]

It is very relevant and DateSerial() is recommended over the other options herein - use what you choose.

Cheers.

 

[strongm]

>It is very relevant

On what basis? The OP suggests that they will be starting with a real date, so the ability (not disputed) of DateSerial to handle 'values which may or may not fall into the range of the parts' is, as far as I can see, completely irrelevant.

And you seem to be avoiding answering the question concerning accuracy.

You state very specifically that DateSerial is 'the easiest/most accurate way'. I'm just trying to find out how or why why you think this is so.