Display name based on date

[EdmondsM]

Hi All, I am trying to put together a cfm page that will display a users name
based on the day of the week. The user selects a range of dates that they want
their name on the list, their name should only show Monday thru Friday. is
there an easy way to accomplish this in CFM?? I hope I made this clear.
Thanks iin advance

[zoeski80]

you can use the DayOfWeek function eg. #DayOfWeek(now())# which will return a
number from 1(Sunday) to 7(Saturday) to tell you which day of the week it is.

There is also a DayOfWeekAsString which will actually return the name of the
day.

So you can do a CFIF or CFSWITCH on the days of the week to determine whether
to show a users name or not.

HTH

Zoe

[EdmondsM]

Hi Zoe, I have gotten that to work since I posted my message using the
DayOfWeek. What I trying to achieve now is if the user selects 3/1/05 -
3/31/05, is there a way to list the numbers out as 1 thru 7. It would continue
to do this until it has reached the total number of days. Thanks in advance.

[zoeski80]

Hi EdmondsM

I am not really sure what you are doing.
Are you showing a calendar and peoples names are supposed to appear only on
the days they selected?
Do you have some sample code that you can post that shows how you're trying to
show these dates/users.

Zoe

[EdmondsM]

It is not really going to be a calendar per say. What is supposed to happen is
then a doctor come to the page he is going to sign up for on month of service.
The weekends they are not on call so those dates need to either blank or in the
future they maybe fill with a weekend on call doc. So it should look
something like the following.
Date Day Doc Name 1 some
doc name 2 another doc name 3 one more doc
name and so on. So if the doc only selects the first two weeks to be on call
then 1 - 14. Making since??

[The ScareCrow]

The attached code should give you a heads up.

Ken

<cfset NumberOfDays = DateDiff(datepart, startDate, endDate)>
<cfset loopTo = NumberOfDays - 1>
<cfloop from="0" to="#loopTo#" index="idx">
<cfif DayOfWeek(DateAdd("d", idx, startDate) GT 1 And DayOfWeek(DateAdd("d",
idx, startDate) LT 6>
Display Name
</cfif>
</cfloop>

[EdmondsM]

ScareCrow, thanks. With a couple of tweaks I got it to work.