Current System Date is not Today's Date

[Raynepau]

Can anyone help


I have a control which sets the date of another control on an after update event

So for example

If [control_1] ="2" Then [Control 2] = Date

I understand that this will set control 2 to the current system date. At the moment it works but sets the date to 02/02/11 rather than today's date of 11/02/11

Is this simply because the current system date is wrong or is there some other issue and also where does the system date originate

Many Thanks

 

[MajP]

OK I am confused. Why not tell us if the system time is correct?

 

[Raynepau]

thanks
Assuming the system date is at the bottom right of my screen on the taskbar then the system date is correct. if the system time is elsewhere I would not no where to look

 

[PHV]

What is the Format property of [Control 2] ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Raynepau]

The control is set to Auto

 

[MajP]

1) What is your country setting for windows? "US", "UK", "Canada", etc..
Control Panel --> Regional and Language Options
2) on a form put an unbound text box and put in the control source
=Date()
Does it show correctly?

 

[SkipVought]

Are you certain that Control_1 resolved to STRING 2?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Raynepau]

MaJP

Country Setting is English (United Kingdom)

I put an ubound text box on a form and set to date and it worked fine

Skip
I think the answer is yes

thanks both for your help