Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Picker Default Value 1

Status
Not open for further replies.

PWD

Technical User
Jul 12, 2002
823
GB
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€$
 
It is very relevant and DateSerial() is recommended over the other options herein - use what you choose.

Cheers.
 
>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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top