Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Binghamton, NY

    Unanswered: Date break down by day of week only

    I am trying to break up dates in Crystal to reflect a certain day out of the week. For example....If I have a selection criteria by start_date between 7/1/04 to 12/31/04, I want to see the details for every Friday only between those dates. Is there a formula or suppression I can do?

  2. #2
    Join Date
    Jan 2005
    Avon Lake, OH


    Try using DayOfWeek.

    E.g in the Record Selection Formula:

    DayOfWeek ({tablename.DateFieldName}) = 6

    If you want to show the day on a report, try this as a formula:

    ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"] [DayOfWeek({tablename.DateFieldName})]
    Last edited by bcummings; 02-01-05 at 11:50. Reason: More information

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts