Display Days in a month

[ahhuang]

I like to create a report(CR version 8) that displays each day with a selection of date range,example:
Start date :01-01-2002
End date:30-01-2002

Report should show 30 days starting from 1 to 30...
1 2 3 4 5 6 7 .....30

thanx for advice

 

[mbarron]

Here is a formula that will get you what you have illustrated above. It allows for spanning of months. 30/4/02 to 2/3/02 will result in a string field of "30 1 2 "


stringvar dates;numbervar loops;stringvar hold;

for loops:= 0 to datediff("d",{start day},{end day})
do(
dates:=hold & totext(day({start day}+loops),0,"&quot&" ";
hold:=dates);

dates
Mike