Date function not working

[danikuper]

Hi,

I have a very simple line of code that is taking the date and adding it to a text box by using the Date function. However, the date that is being shown is not the current system date, but some other date. For example, instead of showing 04/22/2003 it shows 04/11/2003.

I'm using the Now function instead but I'd like to know if someone has any idea of why this is happening.

By the way, can I have with the Now function only the date and not the time?

thanks!

 

[Mile-O]

Don't know why your dates are messed up - this will give you the date part only.

=DateValue(Now())

 

[danikuper]

Thanks, Mile!

It works.

Strange thing this of the Date function not working.. one day it was fine, but today it just won't work...

 

[Mile-O]

Could be a reference thing although if one function is working and the other isn't I don't understand as I believe they are all part of the same library.

 

[Shadez]

I dont know if this is relaited to your problem(cant seem to recreat it) the only date issue i know of is the stuped American MM/DD/YY thing.

ie

if u use

01/08/3 - access would read it as 8th jan 03- not 1st Aug 03

is suggest always using format in string dates to remove this problem format(now,"DD/MMM/YYYY") it cant confuse that.


NOTE this is only a problem when converting to a date from strings - text

ShadeZ