Textbox with today's date

[iProRyan]

Hi Guys,



Got a problem and I can't find where I'm going wrong. I have a textbox and want it to say the current day and date like this: Thursday 19th December 2013.

It is called txtDate and I have set the Control Source to:
=WeekdayName(Weekday(0),False,0) & Date()

Of which is fine, but it keeps saying Sunday instead of Thursday why is this? Can someone help?

Thanks,
Ryan

[amrut]

Set the default value of the text box to =Date() and Format to dddd mmmm dd", "yyyy

This will show today's date as Thursday December 19, 2013. With little tweaking, you can get the desired result except for the "th" part.
To add the "th" may require some code. Never tried.

[lfpm062010]

You were close. Try this.

=WeekdayName(Weekday(Date(),0),False,0) & Date()

[Missinglinq]

That'll get you

Thursday 12/19/2013

not

Thursday 19th December 2013

To get

Thursday 19 December 2013

you can use

=Format(Date(),"dddd") & " " & Day(Date()) & " " & Format(Date(),"mmmm") & " " & Format(Date(),"yyyy")

To add the suffix to the Date, i.e. the st, nd, rd, th, etc., to get something like 19th, will require more work, and for something like this, is more work than I'd be inclined to bother with!

Linq ;0)>

[lfpm062010]

Thank you for the correction. I was lost in thought at that time.

This is what I was trying to post.

=Format(Now(),"dddd d""" & IIf(Right(Day(Now()),2)\10=1,"th",Nz(Choose(Right( Day(Now()),1),"st","nd","rd"),"th")) & """ mmmm, yyyy")

[Missinglinq]

Your last posted code works just fine, for me, in the U.S. What Date Format is Windows set to on your machine? The Access gnomes frequently choke on anything other Format other than than MM/DD/YYYY.

And as basic as it sounds, have you checked to make sure that the Date on your system is correct? When testing certain types of code, I'll play with changing the system dates and forget to reset it, on occasion!

BTW, Now() returns the Time portion of the Date and Time, and many developers only use it when they absolutely need the Time, because having the Time portion can lead to problems, later. If all you need is the date, use Date().

Linq ;0)>