Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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)

qv.JPG

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

3 Replies
brenner_martina
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

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

brenner_martina
Partner - Specialist II
Partner - Specialist II

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