Printing the name of months between dates

Freaky

Hi Guys,
Can anyone help me please on how I can be able to get name of months between two dates. let say
01/01/07 to 30/11/07. I want it to print in my report
January
February
March
April
May
June
July
August
September &
November

Thanks in advance.

kapamarou

Use the date table...

Filter for Period type Month and your dates and get the name.... It is table 2000000007 visible in a new form or report or as a variable. Not in object designer.

garak

Here the table "DATE" is your friend. Set there a filter on "periode type" with the value Month and on field "Period Start" the filtervalue 01.01.07..30.11.07.
Now you can use the values in field Periode Name.

Regards

Freaky

Thanks for the help.But still how can I link the date table to my previous dataitem because that is were the dates are.

Thanks

idiot

You declare Date as a record & query it for the dates you want with it returning you the required result.