aerialv
-
Total Posts
:
4
- Scores: 0
-
Reward points
:
0
- Joined: 10/1/2007
-
Status: offline
|
pls help! pls help!
Tuesday, October 02, 2007 12:04 AM
( permalink)
im making a program that has a periodical reports. it will search the date from and to so i can see in the result page the data from the date entered and up to the date entered. since the date format is like this one, 6/17/2007, i want to see in the result page the real month which is june. so meaning, i want to convert the numerical month into words. here is the example: from: 6/17/2007 to: 8/12/2007 in the result page,, i want to convert this into words like these one: from June 16, 2007 to August 12, 2007 anyone, pls help me! thanks a lot!!
|
|
|
|
ebgreen
-
Total Posts
:
8227
- Scores: 98
-
Reward points
:
0
- Joined: 7/12/2005
-
Status: offline
|
RE: pls help! pls help!
Tuesday, October 02, 2007 2:46 AM
( permalink)
The substitution is easy. Search the forum for "dictionary". Then make a dictionary of the months and use it to substitute for the number.
|
|
|
|
TNO
-
Total Posts
:
2094
- Scores: 36
-
Reward points
:
0
- Joined: 12/18/2004
- Location: Earth
-
Status: offline
|
RE: pls help! pls help!
Tuesday, October 02, 2007 4:45 AM
( permalink)
My preference: Dim MyVar MyVar = MonthName(10, True) ' MyVar contains "Oct".
To iterate is human, to recurse divine. -- L. Peter Deutsch
|
|
|
|
webber123456
-
Total Posts
:
58
- Scores: 0
-
Reward points
:
0
- Joined: 9/20/2007
-
Status: offline
|
RE: pls help! pls help!
Tuesday, October 02, 2007 7:19 AM
( permalink)
|
|
|
|
aerialv
-
Total Posts
:
4
- Scores: 0
-
Reward points
:
0
- Joined: 10/1/2007
-
Status: offline
|
RE: pls help! pls help!
Tuesday, October 02, 2007 3:02 PM
( permalink)
thanks guys but i still dont get it..can u give me a more simpler script? i mean the exact thing to do? im a beginner thats why so im not quite familiar yet.. xD thanks a lot again! hope u can help me on this one!
|
|
|
|
hnikou
-
Total Posts
:
3
- Scores: 0
-
Reward points
:
0
- Joined: 10/20/2007
-
Status: offline
|
RE: pls help! pls help!
Monday, October 22, 2007 11:37 PM
( permalink)
Hi aerialv, If your date is dynamic value. you are able to do by changing your date format from <%=(Recordset1.Fields.Item("todate").Value)%> to <%= DoDateTime((Recordset1.Fields.Item("todate").Value), 1, 4105) %> in result page. you should change "Recordset1" and "todate" to real words in your script. Wishes hnikou
|
|
|
|