Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008

    Unanswered: Issues with "undefined function" error during update from Access 2003 to 2007

    Hi All,

    My company recently upgraded me to Office 2007, and I had a query that pulled a date range of the prior three months to use for calculating demand - now now it's not working. Here was the criteria:

    Between Val(CStr(Year(DateAdd("m",-3,Date())))+Right("0"+CStr(Month(DateAdd("m",-3,Date()))),2)+"01") And Val(CStr(Year(DateAdd("m",-1,Date())))+Right("0"+CStr(Month(DateAdd("m",-1,Date()))),2)+"31")

    I'm getting Undefined function 'Date' in function errors and I changed those to now and got an error for 'Right' as well. Have these functions been eliminated in 2007?

    Any help would be GREATLY appreciated!!!


    I should probably add that the reason all the above is necessary is because the ODBC tables I link to display dates in yyyymmdd format.
    Last edited by truhavoc; 09-18-09 at 16:36.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    According to MS ( the Date function still works in Acc2007 the same way it works in the previous versions of Access.

    May be you have one or several references missing in your converted database (in VBA editor select Tools, References and see if nothing is missing).
    Have a nice day!

  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    When apps run fine on one machine and not on another or run fine in one version and not when run under a newer version, the first thing you have to think about are missing references. And when something such as Date() starts failing you can be assured that this is the problem.

    Here are Doug Steele's detailed instructions on how to troubleshoot the problem:

    Access Reference Problems
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts