[AccessD] Date() not working - MDAC issue or not?

Kath,

A few years ago I noticed this problem on a few computers, and it was a
sporadic problem.  To get around it I put the following in a standard
module:

Public Function CurrentDate() As Date

    CurrentDate = CDate(DatePart("m", Now()) & "/" & DatePart("d", Now()) _
	& "/" & DatePart("yyyy", Now()))

    Exit Function

End Function

Now whenever I need the current date I just write:  txtDate = CurrentDate

No problems for several years now!

Dan Waters
ProMation Systems

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
Sent: Thursday, November 04, 2004 4:23 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Date() not working - MDAC issue or not?

Hoping someone can shed some light here....

A client using Windows 2000 Pro and Access 2000 has been using an mdb
written in Access 2000 for several years. But this week when I installed an
upgrade (same platform), the Date() functions throw errors, as do the
Format() functions.

They have a critical error at the moment caused by Date() notworking which I
need to fix today. I know I could modify these functions to use, eg. Now(),
but is this a MDAC problem? Mine is MDAC 2.7 on Windows XP SP1. 

If I asked my client to download MDAC 2.8 (which I see is the latest) - is
this going to solve the problem?

I do not understand how this upgrade could possible have afftected the use
of these functions??

Thanks

Kath
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com