2. ASPRunnerPro General questions
  3. [SOLVED]  Date format DD-MMM-YY
This topic is locked
[SOLVED]

 Date format DD-MMM-YY

 		1/8/2008 1:18:49 AM
ASPRunnerPro General questions
D
 dyd author

Hello,
How can I set the format for Date field as: DD-MMM-YY (e.g., 07-Jan-08)?
This was possibe in ASPRunner5.0, but the options in ASPRunner5.1 are either short date (e.g., 01/31/07) or long date (e.g., Wednesday, January 31, 2007).
Thank you,
M
 		Michael7 1/8/2008

you can do it in the sql editor
Select

format(([Datefield]),'dd-mmm-yy')as Datefield1,

[Datefield]

From Table
then select Datefield1 on the list & view page &

Datefield for the edit, add & search pages
Regards

Michael
D
 		dyd author 1/9/2008

Michael,
Thanks for your suggestion. But I am getting the following error message -
-------------------------------------------------------------------------

ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/project34/include/commonfunctions.asp, line 251

-------------------------------------------------------------------------

Hello,

How can I set the format for Date field as: DD-MMM-YY (e.g., 07-Jan-08)?
This was possibe in ASPRunner5.0, but the options in ASPRunner5.1 are either short date (e.g., 01/31/07) or long date (e.g., Wednesday, January 31, 2007).
Thank you,
M
 		Michael7 1/9/2008

Post your sql,
Note : My Suggestion was for Access db and there can be minor changes with different db's
which db are you on.
and what is line 251.
D
 		dyd author 1/12/2008

Mich,
Thanks a lot for you help! Your code does indeed work.

Post your sql,

Note : My Suggestion was for Access db and there can be minor changes with different db's
which db are you on.
and what is line 251.