Today's Date

B

Bill Dobie

I have an Input Form where the date may be provided on an earlier
order but sometimes it is a new customer who has never ordered
anything as yet. In that case this is the frst mention of the Customer
and the date should always be today's date. How do I specify that?

Sweet Old Bill
 
G

Guest

Bill

The built-in function 'Now()' will retrieve the current date and time

I'm gathering that the date field is a textbox, so in this case you can set the default value property to '= Now()' and each time a new record is created, the current date will be displayed as the default. This value can still be overwritten on the form if required (it's only a default value)

Hope this helps
Tra

----- Bill Dobie wrote: ----

I have an Input Form where the date may be provided on an earlie
order but sometimes it is a new customer who has never ordere
anything as yet. In that case this is the frst mention of the Custome
and the date should always be today's date. How do I specify that

Sweet Old Bil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top