Is it any function that return name of the day on week .. like Monday,
Tuesday etc.?
ThanksYou could use the format function:
format(fieldname,"ddd")
Mike G.
"Carlos" <cp@.swa.com> wrote in message
news:e8XUzAgFFHA.1476@.TK2MSFTNGP09.phx.gbl...
> Is it any function that return name of the day on week .. like Monday,
> Tuesday etc.?
> Thanks
>|||You can also use the WeekDay function:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctweekday.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike G." <theNOSPAMjunkbox@.comcast.net> wrote in message
news:OV2LhegFFHA.560@.TK2MSFTNGP15.phx.gbl...
> You could use the format function:
> format(fieldname,"ddd")
> Mike G.
>
> "Carlos" <cp@.swa.com> wrote in message
> news:e8XUzAgFFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> Is it any function that return name of the day on week .. like Monday,
>> Tuesday etc.?
>> Thanks
>|||In addition there is a WeekDayName function:
http://msdn.microsoft.com/library/en-us/vblr7/html/vafctWeekdayName.asp
> You can also use the WeekDay function:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctweekday.asp
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Mike G." <theNOSPAMjunkbox@.comcast.net> wrote in message
> news:OV2LhegFFHA.560@.TK2MSFTNGP15.phx.gbl...
>> You could use the format function:
>> format(fieldname,"ddd")
>> Mike G.
>>
>> "Carlos" <cp@.swa.com> wrote in message
>> news:e8XUzAgFFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> Is it any function that return name of the day on week .. like Monday,
>> Tuesday etc.?
>> Thanks
>>
>sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment