anther date question

  • Thread starter Thread starter Southern at Heart
  • Start date Start date
S

Southern at Heart

StrDate is assigned todays date with the Now function, the value looks like
this:
3/25/2010 10:36:48 PM

....I need the value to look like this:
2010/03/25
(the month and day have to be 2 digits)

How do I do this?
thanks.
 
Southern at Heart said:
StrDate is assigned todays date with the Now function, the value looks
like
this:
3/25/2010 10:36:48 PM

...I need the value to look like this:
2010/03/25
(the month and day have to be 2 digits)

How do I do this?
thanks.
Click to expand...


Is StrDate a variable? if so, what type of variable is it? The prefix
"str" usually denotes a string, but sometimes prefixes can be misleading.

If you just want the date, and not the time, you can assign from the Date()
function, rather than Now() -- look in the online help for a comparison of
Date(), Time(), and Now().

Assuming StrDate is a string variable, then you need to format the date into
the desired string. Try this:

StrDate = Format(Date(), "yyyy/mm/dd")
 
Assuming StrDate is a string variable, then you need to format the date into
the desired string. Try this:

StrDate = Format(Date(), "yyyy/mm/dd")

....this should do it, as it needs to be a string.
Thanks. I've tried lots of different syntax with that Format function, but
couldn't quite get it.
Cheers.
 
When I run this code, it changes StartDate to todays date!
StartDate = Format(Date, "yyyy/mm/dd")
....StartDate was something else before it came to this line...
Please help, thanks.
(I'm needing the date to be in that format)
 
When I run this code, it changes StartDate to todays date!
StartDate = Format(Date, "yyyy/mm/dd")
...StartDate was something else before it came to this line...
Please help, thanks.
(I'm needing the date to be in that format)
Click to expand...

That's precisely what you're telling it to do: call the built in Date()
function, convert it to a yyyy/mm/dd text string using the Format function,
and store that text string in StartDate.

What is the context? Is StartDate a variable, a form control, something else?
Do you have a form control or table field named Date? If so, you're running
into the main reason you should NOT do that - Access getting confused about
whether you mean the field or the builtin function!
 
Back
Top