?
Solved

Convert Date() to YYYYMMDD

Posted on 2004-09-18
13
Medium Priority
?
2,566 Views
Last Modified: 2012-08-14
Wondering what the easiest way to convert the standard asp date formats (9/18/2004) to YYYYMMDD format.  I need to query a btrieve database that uses that format.  I coulnd't find an asp function looking online, and for now I have split the date string and put it back together, this just seems like a lot of code for a simple conversion.
0
Comment
Question by:probelaw
  • 4
  • 3
  • 2
  • +3
13 Comments
 
LVL 63

Accepted Solution

by:
Zvonko earned 200 total points
ID: 12093326
My proposal is a two-lines Function:

<%

Function sortDate(pDate)
    aDate = CDate(pDate)
    sortDate = Year(aDate)&Right("0"&Month(aDate),2)&Right("0"&Day(aDate),2)
End Function


  Response.Write sortDate("9/18/2004") & "<br>"
  Response.Write sortDate(Now()) & "<br>"


%>
0
 
LVL 2

Expert Comment

by:Coolhand2120
ID: 12094075
Zvonko's solution is perfect, this is just another way:

function getEurotime()

timetoday = CStr(FormatDateTime(Now() + 14, 2))
todayinUS = Split(timetoday, "/")
getEurotime = todayinUS(1) + "/" + todayinUS(0) + "/" + todayinUS(2)

end function

This method takes more memory for sure, may be faster though.  Like memory or speed mater at that micro level.

BTW Zvonko are you a Croat?

-Coolhand2120
0
 
LVL 2

Expert Comment

by:Coolhand2120
ID: 12094279
Ooops Just noticed my function there set the time today + 14 days.  I used this script in an application where that was done.

This line:

timetoday = CStr(FormatDateTime(Now() + 14, 2))


Should read:

timetoday = CStr(FormatDateTime(Now(), 2))


-Coolhand2120
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 63

Expert Comment

by:Zvonko
ID: 12094840
I am Mecedonian. But my first name is Crotian ;-)
0
 
LVL 1

Expert Comment

by:InVisal
ID: 12095145
here my simplest code :D one line code

<%
  Function EuroDate(strDate)
      EuroDate = Format(CDate(strDate),"YYYY/MM/DD")
  End Function
%>
0
 
LVL 63

Expert Comment

by:Zvonko
ID: 12095227
And what IIS version does your Format() method work?
0
 
LVL 2

Expert Comment

by:Coolhand2120
ID: 12096558
I think thats a VB function.  You can use VB functions in ASP by creating activeX DLLs, but that seems a bit extreme.  I'm not sure ASP supports the VB format function, I'm quite possibly wrong though.

-Coolhand2120
0
 
LVL 10

Expert Comment

by:dij8
ID: 12097911
I use a function found at http://www.adopenstatic.com/resources/code/formatdate.asp

It may be a bit much for what you want but it allows for all sorts of date and time formatting.  You may end up using it for a multitude of other things you never bothered with because they were too much hassle.
0
 
LVL 23

Expert Comment

by:apresto
ID: 12104587
http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_21067836.htm

The above is a question i asked along the lines of yours,

this is the accepted answer:

"
Date - a reserved word for Access? Try enclosing Date in square brackets.

SQL = "UPDATE GameDates set [Date]='" & year(d) & "/" & month(d) & "/" & day(d) & "' where DateID = " & i
"
check out the question for full details
0
 
LVL 23

Expert Comment

by:apresto
ID: 12104597
in your case just re-arrange the statement so that yyyy is first etc
0
 
LVL 10

Expert Comment

by:dij8
ID: 12106295
Also remember to set your locale so that when seperating months and days it does them in the right order.  http://www.devguru.com/Technologies/vbscript/quickref/LCIDchart.html
0
 

Author Comment

by:probelaw
ID: 12125976
Zvonko's two line function seems like the easiest thing to use for what i need to accomplish.  I can just use it as an include in the pages I need it.  Thanks!
0
 
LVL 63

Expert Comment

by:Zvonko
ID: 12127854
Thanks for points and for the feedback.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question