auto date function?

[collegeprodigy]

just wondering...does anyone know if there's an auto date function in access?

 

[Mile-O]

What exactly do you mean by auto-date?

If you mean "if I put a dae in can I automatically get a date one year from that date?" then what you are looking for is the DateAdd() function.

Otherwise, I don't know what you mean.

 

[Rob.Mills]

Are you thinking of a time stamp like when the record was created?

If that's the case you can put Date() in the default value of that field in the table itself.

You could also put Now() which will give you the date and time.

 

[chewy]

just curious...why when you put in the date function do the parameters disappear? Is it because the function takes no parameters? Or does it take parameters? It doesn't seem that it would. Thanks

 

[boblarson]

When you use DATE and TIME in code, you don't have to use the () and it will actually get rid of it. It is because it is a function with no parameters.