Sunday, March 25, 2012

Day of the week function

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

No comments:

Post a Comment