If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Working out ages from DOB.
i had this code in a select query which ran fine in 2003...
DateDiff("yyyy",[dateofbirth],Now())+Int(Format(Now(),"mmdd")Format([dateofbirth],"mmdd")) now in 2007 i'm told.... undefined function "format" in expression. any help will be much appreciated as i am about to revert to 2003 in despair! |
#2
|
|||
|
|||
Working out ages from DOB.
For the code to work in Access 2007, you may need to specify that your
database is in a trusted location: Office Button | Access Options | Trust Center | Trust Center Settings Alternatively, you may need to solve a problem with your library references: http://allenbrowne.com/ser-38.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "mike@work" wrote in message ... i had this code in a select query which ran fine in 2003... DateDiff("yyyy",[dateofbirth],Now())+Int(Format(Now(),"mmdd")Format([dateofbirth],"mmdd")) now in 2007 i'm told.... undefined function "format" in expression. any help will be much appreciated as i am about to revert to 2003 in despair! |
Thread Tools | |
Display Modes | |
|
|