Skip to main content
A
Anonymous
May 12, 2008
Question

Creating a weekly calendar - need help

  • May 12, 2008
  • 2 replies
  • 348 views
Hi everyone,

I have never created anything like this before, in fact it is my first attempt at any kind of calendar...so be kind :)

I am trying to create a weekly calendar for my tech. It works like the following:

Across the top is the tech names,
down the side is the day of the week.

tech1 tech2 tech3 tech4 tech5
Sunday
Monday
tuesday
Wednesday
Thursday
Friday
Saturday

Then I just want to run a basic cfquery that gives me all the open tasks by tech where the scheduled date would dynamically place into the corresponding day.

Is this possible?

I have some code written and have attached

Any input would be helpful.
Thanks
Sue
    This topic has been closed for replies.

    2 replies

    A
    Anonymous
    May 13, 2008
    Good Morning,

    Well I got it to work. It was all in my cfif. I changed it from
    <cfif #DayOfWeek(getBWschedule.duedate)# IS 7> to
    cfif DayOfWeek(getBWschedule.duedate) IS 7> and it seemed to work.

    Thanks Sue
    C
    cputnam14
    Known Participant
    May 12, 2008
    Would you be opposed to changing your layout a little bit? If you have the techs going down the side instead of the top, this would be easier...in my opinion.

    The you could just have a separate query for each tech and an output for each one as well.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices