Date variable for 2 weeks

[veles]

I am using crystal XI.

I have a date field that I need to work with. This is the date a shift occured.

Using that date I created a formula for pay periods starting on a Monday and going forward 2 weeks, which is working fine.

I need a variable that will give me the date for each day of that pay period to display the days and dates horizontally in ther own display formulas (formula for day 1 to 14 in the pay period).

Thanks

 

[Madawc]

Do you know about crosstabs? A crosstab would arrange shift details by date, though only for dates that had at least one shift. It might start off grouping dates as weeks, but this can be adjusted.

Crosstabs are found under Insert and are one of Crystal's most useful features.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP