converting date to dayNumber

Post Author: kalyan

CA Forum: Formula

Hi i have a typical problm .. , i have a column with receiveddate from which i should show some count of recods on that date

here is the requirement

The Day 0 should be u2018todayu2019s dateu2019 and items appearing in that row should be for items with a received date of u2018todayu2019. The Day 1 should be u2018yesterdayu2019s dateu2019 and items appearing in that row should be for items with a received date of u2018yesterdayu2019. This should go to Day 16+.

i should show this in reports like this

DayNum ReceivedDatre recCount

Day 0 08-30-2007 -- 5

Day 1 08-29-2007 -- 15

Day 2 08-28-2007 --10

like this

Thanks