jwebster77
asked on
Get day of week in CR based on current date.
Hello experts. Here is what I need to do, I need to evaluate what the current day is. So, basically something like this
If CurrentDate = Monday Then
Do something
Else If CurrentDate = Tuesday Then
Do something
etc., etc.
Can anyone tell me how to go about doing this. Thanks!
If CurrentDate = Monday Then
Do something
Else If CurrentDate = Tuesday Then
Do something
etc., etc.
Can anyone tell me how to go about doing this. Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Peter beat me to it. I'll just add that you can also add a second argument to DayOfWeek if you want the week to start on some day besides Sunday. For example, DayOfWeek (CurrentDate, crTuesday). crMonday, crTuesday, etc. are CR constants for the day numbers. Or, you can just use 1, 2, etc.
James
James
ASKER