[Webinar] Streamline your web hosting managementRegister Today


Accesss Error-undefined function Format

Posted on 1999-07-01
Medium Priority
Last Modified: 2010-04-09
When I access date columns with format function in SQL Query
Access returns error 'undefined function format'.This is working some times and some times not.
What could be the reason
Question by:philipkv
  • 3
  • 2

Author Comment

ID: 1851524
I am Accessing DB through ASP and ADO
LVL 10

Expert Comment

ID: 1851525
Please post your code.  Thanks.

LVL 10

Accepted Solution

MasseyM earned 120 total points
ID: 1851526
Make sure the field is a date field in the SQL server.  Also, make sure the VBScript function that you are using is aware of the format the date is in before calling it... For a more specific answer, please post your code..
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.


Author Comment

ID: 1851527
Hi Massey, format function i used is the built in function of Jet SQL.When i restart the system it works for some time. Then again returns undefined function "Format". I think this comes from ODBC Driver for Access.
LVL 10

Expert Comment

ID: 1851528
Can you post your code so we can see that part that is being troublesome?

Expert Comment

ID: 6810416
Fixed the -1 problem on this question.
Escrow points corrected.

Community Support Moderator
Experts Exchange

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
In this tutorial viewers will learn how to embed an audio file in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: : The declaration should display (CODE) HTML5 is supported by the most recent versions of all major browsers…
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…
Suggested Courses

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question