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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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..
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article discusses four methods for overlaying images in a container on a web page
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 …
In this tutorial viewers will learn how to style transparent/translucent elements using alpha transparency in CSS Start with a normal styled element, such as a div.: Define its "background-color" property as "rgba (255, 255, 255, .5): The numbers in…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

719 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