Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Format Date 1
- Thread starter djmc
- Start date
-
1
- #2
faq333-3194
____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]
____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]
djmc,
You can try the below... Asumming that you have a predefined format like the one that you had posted...
<%
origdate = "01-01-2003"
arrayorigdate = Split(origdate, "-"
arrayorigdate(2) = Right(arrayorigdate(2) ,2)
newdate = join(arrayorigdate,"-"
response.write newdate
%>
HTH..
Happy programming...
You can try the below... Asumming that you have a predefined format like the one that you had posted...
<%
origdate = "01-01-2003"
arrayorigdate = Split(origdate, "-"
arrayorigdate(2) = Right(arrayorigdate(2) ,2)
newdate = join(arrayorigdate,"-"
response.write newdate
%>
HTH..
Happy programming...
the faq shows methods of breaking a date up and reassembling it, search google for "FormatDate Function"
it's built in to VB 5/6 and has ALOT of date display and modification functionalities even down to spitting out the text based representation of a date (Monday, June 15, 1999) etc ..
it's built in to VB 5/6 and has ALOT of date display and modification functionalities even down to spitting out the text based representation of a date (Monday, June 15, 1999) etc ..
DreXor
Please read the FAQ again. I've included every possibility including the FormatDate Function
<src FAQ>
second method is the FormatDateTime function
many VBers will know this function well, but overlooked many times in vbscript/ASP
example:
Dim curDate
curDate = Now()
Response.Write "vbGeneralDate - " & FormatDateTime(curDate, vbGeneralDate) & "<BR>"
Response.Write "vbLongDate - " & FormatDateTime(curDate, vbLongDate) & "<BR>"
Response.Write "vbShortDate - " & FormatDateTime(curDate, vbShortDate) & "<BR>"
Response.Write "vbLongTime - " & FormatDateTime(curDate, vbLongTime) & "<BR>"
Response.Write "vbShortTime - " & FormatDateTime(curDate, vbShortTime) & "<BR>"
____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]
Please read the FAQ again. I've included every possibility including the FormatDate Function
<src FAQ>
second method is the FormatDateTime function
many VBers will know this function well, but overlooked many times in vbscript/ASP
example:
Dim curDate
curDate = Now()
Response.Write "vbGeneralDate - " & FormatDateTime(curDate, vbGeneralDate) & "<BR>"
Response.Write "vbLongDate - " & FormatDateTime(curDate, vbLongDate) & "<BR>"
Response.Write "vbShortDate - " & FormatDateTime(curDate, vbShortDate) & "<BR>"
Response.Write "vbLongTime - " & FormatDateTime(curDate, vbLongTime) & "<BR>"
Response.Write "vbShortTime - " & FormatDateTime(curDate, vbShortTime) & "<BR>"
____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]
well, alright I'll make it clear on the FormatDate!!! function
![[lol]](/data/assets/smilies/lol.gif "[lol] [lol]")
____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]
____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]
- Thread starter
- #8
vbGeneralDate - 6/27/2003 2:57:03 PM
vbLongDate - Friday, June 27, 2003
vbShortDate - 6/27/2003
vbLongTime - 2:57:03 PM
vbShortTime - 14:57
This is the output that I got.
Apparently vbShortDate returns 6/27/2003 and not 6/27/03 (which is what i want)
vbLongDate - Friday, June 27, 2003
vbShortDate - 6/27/2003
vbLongTime - 2:57:03 PM
vbShortTime - 14:57
This is the output that I got.
Apparently vbShortDate returns 6/27/2003 and not 6/27/03 (which is what i want)
.......
.......
then you need to format your date with a bit of intervention
eg: right() function and rebuild the date
MyYear = right(Year(Date()),2)
____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]
.......
then you need to format your date with a bit of intervention
eg: right() function and rebuild the date
MyYear = right(Year(Date()),2)
____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]
as gladxml already stated I see!
____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]
____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
