Area chart X-axis need to be as date number

[#1]

I have requirement to display area chart where I need to show date number in x-axis of chart.

Date(MM/DD/YYYY)	Expected chart x-axis
1/13/2012	1
1/16/2012	2
2/1/2012	3
2/7/2012	4
2/20/2012	5

I have to limit dimension which depends on another date i.e quater start date.

Please help me on this.

Thanks

[Gysbert_Wassenaar]

If you don't have many dates you could use this:

=match(MyDate, '1/13/2012', '1/16/2012', '2/1/2012', '2/7/2012', '2/20/2012')

or perhaps =aggr(rank(-MyDate),MyDate)

If you have more dates it's better add an extra field in the load script, or maybe use the dual function.