DELETE ME!

[GTaudiophile]

I am in Table Design View. I have a field called "Input Date" with the "text" format. In the "Default Value" section of the Field Properties I have =Date().

I was hoping this would auto-input today's date in the Input Date field as I begin adding a new record into the database.

But it does nothing.

What am I doing wrong?

Edit: And I KNOW this isn't OT...but this is where the people who know hang out!

 

[MisterJackson]

Tisk Tisk.....a lifer in the wrong forum 😛

 

[nakedfrog]

Try Now() or GetDate(), I'm not sure.

 

[KLin]

1. change it to a datetime datatype
2. wrong forum

 

[GTaudiophile]

Originally posted by: nakedfrog
Try Now() or GetDate(), I'm not sure.

=Now() does the trick! Thanks!

 

[KLin]

You shouldn't keep the field as a text datatype. You may want to consider changing it to a Date/Time datatype.

 

[GTaudiophile]

Originally posted by: KLin
1. change it to a datetime datatype
2. wrong forum

LOL! I found an online tutorial through google search that said NOT to make it Date/Time and use Text instead.

Thanks

 

[KLin]

Originally posted by: GTaudiophile

Originally posted by: KLin
1. change it to a datetime datatype
2. wrong forum

LOL! I found an online tutorial through google search that said NOT to make it Date/Time and use Text instead.

Thanks

Link?

 

[GTaudiophile]

Originally posted by: KLin

Originally posted by: GTaudiophile

Originally posted by: KLin
1. change it to a datetime datatype
2. wrong forum

LOL! I found an online tutorial through google search that said NOT to make it Date/Time and use Text instead.

Thanks

Link?

Could be that my assistant and I read it wrong...

 

[KLin]

Originally posted by: GTaudiophile

Originally posted by: KLin

Originally posted by: GTaudiophile

Originally posted by: KLin
1. change it to a datetime datatype
2. wrong forum

LOL! I found an online tutorial through google search that said NOT to make it Date/Time and use Text instead.

Thanks

Link?

Could be that my assistant and I read it wrong...

When the guy says textbox he's just referring to a controlbox on a form. For a field in a table, the datatype really needs to be datetime to be able to query against it correctly. Otherwise you'd have to start using a function called CDate to convert the text to a date in all of your queries and reports.