question? What is the difference between date() and date$()

[Guest]

I know that I should have asked this question as part of my previous
question, but I forgot about it since it has been a long day, but here goes.

In some of the forms and tables that I have seen used in the database I am
working with, I have seen the use of the date function to display the current
date. Sometimes, the function was use as date() and other times, the
function was used as date$(). What would be the difference between the
date() function and the date$() function? I did a search on the web and have
read a few books on access, but I cannot see any information on why the $ was
added to the date function. In both cases it seems to work.

Edward Letendre.

 

[John Vinson]

What would be the difference between the
date() function and the date$() function?

Date() returns a Date/Time value; Date$() returns a String.

The $ and % and other suffixes are holdovers from ancient Basic code;
I'd recommmend expunging them.

John W. Vinson[MVP]