Date Syntax

[Alex]

Hi

In Acces I am trying to insert current date, and current date +10 into
fields using Date() and Date()+10 - should this work please?

Thanks

Alex

 

[Jowsie]

Sure, the Date() function works in Access.

Jowsie

 

[Douglas J. Steele]

As Jowsie says, the Date() function should work in Access. What's happening
when you try to use it?

My question is why are you storing the second date (10 days later) in the
table when you can recalculate it any time you want? That's actually a
violation of relational database theory: you should never store values that
are completely dependent on other fields in the row.

 

[Alex]

Hi Douglas

yes I am trying to sort out this database and revamp it, and I agree with
you - it will be removed in due course, when I've worked out what else is
reliant on this if anything.

My date fields were not being updated, and I wasn't getting any error
message, however I think it was a rouge space in the code that was causing
the probem - sorted now anyway - thanks

Alex