Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want use Dayname(today()) to display Thursday, friday like.... But not getting the right forumula. Thanks,
Change your SET variables like
SET DayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
Then in text box write
=WeekDay(today( ) ) this gives Thrusday
HI Madu,
Use
WeekDay(Today())
instead.
I hope it helps,
Carlos
weekday(today()) will work for you
=WeekDay(Today())&', '&num(weekday(Today()))&' '&month(Today())&' '&year(today()) Output is Thursday, 3 Apr 2014 I am missing like 3rd, 4th, 5th, 2nd like?? Thanks,
Hi,
But Weekday(today( ) ) will not give exactly Thrusday please check if i am wrong
It gives
Weekday(today( ) ) Thu instead of Thrusday
I used this SET DayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Satday;Sunday'; So I get Thursday