Selecting a column heading based on a formula value.

[thepp26]

I am working with a table of employee schedules that list Mon, Tue, Wed .... as column headings to a bollean field. Therefore, if they work on Monday then Mon = true.. I am trying to select their schedule row by converting a date to (Weekdayname, abbrev.)..

I am confused with the Crystal syntax..

(ScheudleTable.(Day of Week)) = True

Anyone ever run into this..

 

[dgillz]

DayofWeek({Datefield}) will return the day name - Monday, Tuesday etc.

I think you need to test if the various date fields are null like this:

Not (IsNull({SchedTable}))

This should return true or false Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office