Solved

Convert Date() to YYYYMMDD

Posted on 2004-09-18
13
2,550 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 50 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Autosum input type=text when checkbox is true 28 85
JQuery Date Time picker not showing 29 115
Adding Datediff to staistics page 2 49
SP to delete duplicates 15 63
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now