formatting date

  • Thread starter Thread starter ccw
  • Start date Start date
C

ccw

I have a date field in a table that formats the date like this:
4/13/2004

somehow - either right in Access or (preferrably) in my ASP(VB) I nee
to rearrange it to:
20040413

is this possible
 
I have a date field in a table that formats the date like this:
4/13/2004

somehow - either right in Access or (preferrably) in my ASP(VB) I need
to rearrange it to:
20040413
Click to expand...

Certainly. Use a Format property of yyyymmdd, or to convert it to a
Text string use

strDate = Format([datefield], "yyyymmdd")
 
How about this: what if you're wanting to take the date they entered an
then format it into a [week of the year]/year format?

I don't want it to just format it though because it'll still STORE i
as the date they entered. I need to CHANGE what they enter int
ww/yyyy format and store ONLY the ww/yyyy. I've tried with VB, but th
best I can come up with shows it as, for example a date in the 10t
week, 10/1/2004. I'm not understanding why it's converting it to
short date format. If anything else looks at it, such as a query
it'll see it as Oct 1, 2004. Got any suggestions
 
Back
Top