how: set one column to be "Today"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IN MS Access, how do i set a column, so when i open the table, it always show
the date "today".

Eg.: When i open the table, the column always shows "10/Sep/2007" as the
date today ?

Thank you very much ^_^!
 
In tabledesign goto the appropriate field and in the fieldproperties set the
defaultvalue of the appropriate field to Date(). This will display todays
date as a default value.

hth
 
Beware it will only have today's date for records created today. If you open
the table tomorrow it will still have today's date there and not tomorrow's
date.

In a query or unbound textbox of your form or report use like this --
Query -
Today is : Date()
Form or report
= Date()
 
You must log in or register to reply here.

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

Similar Threads

Excel How to calculate in excel number of open actions that expired (older then today) 0
Show the date closer to today & bigger & smaller than today 5
Using Crosstab column headings for conditional formatting in report 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel How to get the number of days an item was opened from the today's date. 14
Max & Min Dates 0
Excel Colour code dates 1
Excel Excel VBA Script help 0

Back
Top