Skip to Content
0
Former Member
Dec 18, 2013 at 03:45 PM

Add dates and timings in crystal reports

28 Views

I would like to run the report, those who work fulltime on weekdays.

For example:

Conditions to write a filter# if the table.Status= active (still working online) from the Friday on/before 7pm (table.start date) to Sunday 4pm on/after (table.end date) then I have to display his records

Condition#If the user start at Friday after 7pm and logsoff before Sunday 4pm then I need to eliminate his records

Note: IF the user starts working from Friday (startdate with variable timings) definitely the user will quit sometime around either Saturday or Sunday late night

I am using the, Table.Status, Table.startdate and Table.end date fields.

  1. In the report- selection formulas-record. I need to create a filter to eliminate weekend record users those who work work for only small time on weekends

Attachments

Untitled.jpg (22.2 kB)