Today's Short Date in Form

[joeserrone]

I have an Access Form that captures On Current Event the timestamp, I also want to capture today's date in short format mm/dd/yy. How do I accomplish this in VBA? I currently have the code below to capture the timestamp

Private Sub Form_Current()
Me.Initial_Timestamp = Now()
Earns_Processor.Value = [Forms]![PowerUserForm]!cboNameEnter
Me.RDepositorAcct.SetFocus
End Sub

 

[ecawilkinson]

Try:

todaysdate = Date()

HTH,
Chris

 

[joeserrone]

I tried this but but VAB removeds the () from Date and it doesn't write it to the field on the form

Private Sub Form_Current()
Me.Initial_Timestamp = Now()
Me.Date = Date
Earns_Processor.Value = [Forms]![PowerUserForm]!cboNameEnter
Me.RDepositorAcct.SetFocus
End Sub

 

[joeserrone]

Sorry! I realized that I called the field Date instead of a unique name.

Thanks Again