Capital Day in Date

  • Thread starter Thread starter Douglas J. Steele
  • Start date Start date
D

Douglas J. Steele

Me.LblInfo.Caption = UCase(Format(Date, "dddd" & " " & "mm/dd/yyyy"))
 
I need to get this
MONDAY 7/23/2007
And I'm getting this
Monday 7/23/2007

I currently have....
Me.LblInfo.Caption = Format(Date, "DDDD" & " " & "mm/dd/yyyy")

I tried this
Me.LblInfo.Caption = Format(Date, "Format(DDDD,>)" & " " & "mm/dd/yyyy")

This is on a label.
Any help appreciated.
Thanks
DS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date formats 1
Day of Week from dd/mm/yyyy 7
date calculations - please help 2
Stumped By Dates 4
Date problem 5
WHats wrong with this query? 4
Syntax Error 4
convert date 1

Back
Top