|
View previous topic :: View next topic
|
| Author |
Message |
m_lekshmi13
New User
Joined: 23 Apr 2005
Posts: 6
|
|
|
|
| a date will be inputted i should get the particular day of the week |
|
| Back to top |
|
 |
mmwife
Super Moderator
Joined: 30 May 2003
Posts: 1592
|
|
|
|
Pick any past date that is a Sunday; subtract your date from it using one of the date intrinsic functions. Divide by 7. The remainder will be:
0 if your day is Sunday
1 if your day is Monday
.
.
.
6 if your day is Saturday |
|
| Back to top |
|
|
m_lekshmi13
New User
Joined: 23 Apr 2005
Posts: 6
|
|
|
|
| thanx jack for ur suggestion |
|
| Back to top |
|
|
|
|
