danny-t

Have had a look around the forum and found out a bit about setting date formats (mainly that its a pain in the (_|_)! )

Anyway i'm returning a date and setting the format of a textbox using: -

Dim s As String
txtTextbox(21) = Format(Date, "dddd" & ", " & " mmmm d" & ", " & "yyyy")

which gives me the exact format I want, only problem is it always just gives todays date even though in the database its stored as a differnt date.

Any help would be really nice

danny-t

Quote:

---

Originally Posted by danny__t
Have had a look around the forum and found out a bit about setting date formats (mainly that its a pain in the (_|_)! )

Anyway i'm returning a date and setting the format of a textbox using: -

Dim s As String
txtTextbox(21) = Format(Date, "dddd" & ", " & " mmmm d" & ", " & "yyyy")

which gives me the exact format I want, only problem is it always just gives todays date even though in the database its stored as a differnt date.

Any help would be really nice

---

Sorry to have bothered you guys, soon as I posted I sorted it (seem to be doing that a lot lately) well for those interested i changed it to: -

Dim s As String
txtTextbox(21) = Format(txtTextbox(21), "dddd" & ", " & " mmmm d" & ", " & "yyyy")

noi_max

Ahhh yes, helpful, but what's with the variable?

It looks like you're declaring a variable then formatting text. What's the variable for?