FormatDateTime issue

[kenhutchings]

I hope someone out there can help me...

Im using FormatDateTime(Now,vbLongDate) and I expected to get:

Tuesday 11 January 2005
but what i actually get is:

11 January 2005

any ideas??

Thanks in advance ;0)

 

[Lothario]

you need to do some manipulation to get the desired output...

use the below three functions and concatenate them

day(yourdatefield) ---- 11
MonthName(Month(yourdatefield))----January
Year(yourdatefield)---- 2005

-L

 

[Lothario]

or if you want today's date...use the date() function..

day(date()) ---- 11
MonthName(Month(date()))----January
Year(date())---- 2005

so concatenate them...

<%=day(date())%>&""&<%=MonthName(Month(date()))%>&""&<%=Year(date())%>

-L

 

[kenhutchings]

That still gives me the output i had before

I would like to get the day on there as well eg: Tuesday

Many thanks tho

;0)

 

[Lothario]

oops..my fault...

you were missing parenthesis...

this shud do it

FormatDateTime(Now(),vbLongDate)

-L

 

[Lothario]

if that still doesnt work...then try...

<%=dayname(day(date()))%>&""&<%=day(date())%>&""&<%=MonthName(Month(date()))%>&""&<%=Year(date())%>

-L

 

[Lothario]

if that still doesnt work...then try...

<%=dayname(day(date())%>&""&<%=day(date())%>&""&<%=MonthName(Month(date()))%>&""&<%=Year(date())%>

-L

 

[kenhutchings]

Thanks a lot Lothario but what I ended up using was
<%=weekdayname(weekday(date()))%>&nbsp;<%=day(date())%>&nbsp;<%=MonthName(Month(date()))%>&nbsp;<%=Year(date())%>

Without your help id have never got there

;0)

 

[Lothario]

no problem...i am glad that it worked for you...

-L