Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Thanks, I will try. Resolved it also by input into expression editor "Year(MyDate)".
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
Thanks, I will try. Resolved it also by input into expression editor "Year(MyDate)".
of course you can, but in some cases you have to be careful and use DISTINCT. Listboxes from a field shows allways distinct values.