cmickle
May 8th, 2006, 12:14 PM
Stumped... Been through too many posts to count...
What seems to be easy is not, Any help appreciated......
2 formulas: #1: date(April1 to April 30, 2006); #2 date1(April 1 to April 30, 2005); grouping based on dates in database, daily.
The problem I have encountered is that the dates appear correctly but staggered. 2005 in second column, then 2006 in first column after last day of April. I need them to be side by side. Using -365 works but, it does not reflect the data in that database. There is no Sunday Data and utilizing -365 produces Sundays. I can not get them to be in the same row.
Specifically, I need to show both dates in the same report then compare ie: April 3, 2005: Monday to April 4, 2006: Monday.
I am trying to do this without sub-reports.
attachment added to show what it should not look like.
What am I missing?
What seems to be easy is not, Any help appreciated......
2 formulas: #1: date(April1 to April 30, 2006); #2 date1(April 1 to April 30, 2005); grouping based on dates in database, daily.
The problem I have encountered is that the dates appear correctly but staggered. 2005 in second column, then 2006 in first column after last day of April. I need them to be side by side. Using -365 works but, it does not reflect the data in that database. There is no Sunday Data and utilizing -365 produces Sundays. I can not get them to be in the same row.
Specifically, I need to show both dates in the same report then compare ie: April 3, 2005: Monday to April 4, 2006: Monday.
I am trying to do this without sub-reports.
attachment added to show what it should not look like.
What am I missing?