Using Date to put current date in a field 2

[kiwieur]

Hi people,
can anyone see what is wrong with this small piece of code please. When I try to run it I get the message invalid use of Null and it highlights the line.

CLdate = Date

Private Sub Closed_AfterUpdate()
Dim CLdate As String
CLdate = Date
[ClosedDate] = CLdate
End Sub

Regards

Paul

 

[SkipVought]

Hi,

Dates and not strings.

Dates are NUMBERS. faq68-5827

Private Sub Closed_AfterUpdate()
  [ClosedDate] = Format(Date, "ddd mmmm dd yyyy")
End Sub

Skip,

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

 

[PHV]

Seems like you have a control named Date.
What about this ?

CLdate = VBA.Date

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

 

[kiwieur]

Skip/PHV,

Sorry for not replying sooner and thanks for your input, PHV was right I did have a contol named date I have changed this to DDate and now all is OK

Regards

Paul