db date formatting

  • Thread starter Thread starter mettá
  • Start date Start date
M

mettá

Some time ago I managed to get dates to display like this;

Wednesday 29 April 2009

The code to do this is;

<% =WeekdayName(Weekday
(CDate(FP_FieldVal(fp_rs,"from1"))))%>&nbsp;<%=FormatDateTime(CDate(FP_FieldVal(fp_rs,"from1")),
vbLongDate)%>

However I would like to do this;

Wed 29 Apr 2009

Can anyone help
M
 
Just add the optional abbreviate parameter as true to your WeekdayName code
See http://www.devguru.com/technologies/vbscript/quickref/weekdayname.html

<% =WeekdayName(Weekday(CDate (FP_FieldVal(fp_rs,"from1"))),true)%>
&nbsp;
<%=FormatDateTime(CDate(FP_FieldVal(fp_rs,"from1")), vbLongDate)%>


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Some time ago I managed to get dates to display like this;
|
| Wednesday 29 April 2009
|
| The code to do this is;
|
| <% =WeekdayName(Weekday
| (CDate(FP_FieldVal(fp_rs,"from1"))))%>&nbsp;<%=FormatDateTime(CDate(FP_FieldVal(fp_rs,"from1")),
| vbLongDate)%>
|
| However I would like to do this;
|
| Wed 29 Apr 2009
|
| Can anyone help
| M
|
|
 
Back
Top