All dates into one marking, year 2009, 2010...

[#1]

Hi

I have a box with all the startdates (left in picture). My goal is to get a similar box to the one in buttom on picture. The only I get is the one in the middle and to the right, so the months are correct but I get all the year instead of just 2009, 2010, 2011 ... to cover all the post in that year. To get the months I´d used NUM(month(STARTDAT), '00') as MONTH

Anyone that have any suggestions? (Table name is startdat and month. Table in the middle is the same as startdat but just changed the document settings to date and only YYYY)

[brenner_martina]

Hi, hofstedt,

you can enter in your script the following functions, that creates fields for year, month, week,... then you can use them as a listbox:

Load

     ..,

     date,

     Month(date) As Month,

     Year(date) As Year,

     Week(date) as Week,

     ...

From ...;

Greetings from Munich

Martina

EVACO GmbH

[#3 · Accepted solution]

Thanks, I will try. Resolved it also by input into expression editor "Year(MyDate)".

[brenner_martina]

of course you can, but in some cases you have to be careful and use DISTINCT. Listboxes from a field shows allways distinct values.