AppleEater
Registered User.
- Local time
- Today, 14:19
- Joined
- Feb 27, 2002
- Messages
- 15
I'm trying to use the expression Date () in some of my forms but it doesn't work. I have to use the Now () expression. What's the problem ? How can I resolve it ?
Date()
- Thread starter AppleEater
- Start date
- Local time
- Today, 08:19
- Joined
- Feb 28, 2001
- Messages
- 30,500
We need to know two things:
1. The specific error message or other symptom
2. The context in which Date() fails.
Post this and we can take a shot at it for you.
1. The specific error message or other symptom
2. The context in which Date() fails.
Post this and we can take a shot at it for you.
AppleEater
Registered User.
- Local time
- Today, 14:19
- Joined
- Feb 27, 2002
- Messages
- 15
OK. An example.
I want to put an unbound field [DateInfo] which will give the info Date () in Shortdate format.
When in work status, the [DateInfo] field shows "Name#" as if it doesn't recognize the expression Date ().
After that, I would like to calculate (in the same form) the difference between [DateInfo], or simply Date (), and an other date field. The same problem comes again.
An other info. When I write "=date" in the defaultvalue or the Control Source and press enter, my system understand and write "=[date]" as if it think it's a field name.
...problem?
I want to put an unbound field [DateInfo] which will give the info Date () in Shortdate format.
When in work status, the [DateInfo] field shows "Name#" as if it doesn't recognize the expression Date ().
After that, I would like to calculate (in the same form) the difference between [DateInfo], or simply Date (), and an other date field. The same problem comes again.
An other info. When I write "=date" in the defaultvalue or the Control Source and press enter, my system understand and write "=[date]" as if it think it's a field name.
...problem?
- Local time
- Today, 08:19
- Joined
- Feb 28, 2001
- Messages
- 30,500
Just as a crazy thing to try, on your form click in the text box that will be your date. Make sure that the box says "Unbound" before you start ANYTHING. Now Right-click in the box and select "Build". Then get into the "functions" option in the little tree diagram on the lower left. Then built-in functions. Then in the middle list, select date/time functions. Finally, find "Date" in the right-hand list. When the upper box shows "Date()" then click OK.
Now see what it does.
Now see what it does.
AppleEater
Registered User.
- Local time
- Today, 14:19
- Joined
- Feb 27, 2002
- Messages
- 15
In the upper window of the builder, the expression Date () is written. When I return to form view, nothing appears...
R
Rich
Guest
You have a missing reference, or you are not entering the default value correctly, it's just =Date() without brackets. search here for solutions on missing references if that's a further problem
Last edited:
I'm having the same problem with the Date() function. I have over 50 pc's in my network all running Access 2000 on an XP Pro platform and the problem started only a couple of days ago on 6 of the PC's. The databases with the problem have been working for the last couple of years with no errors. I'm baffled!!
