Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
why when creating a list based on this expression "year(doc_date)" or "month(doc_date)"- selecting one of the values works, but the selected value appears white (not green)?
thanks
shlomo
i am not 100 % sure...but may be because there is more than one year of data present and there is not one-one relationship,
When you use year(doc_date) as a list box expression, you are selecting all of the individual doc_dates. You can see this if you also have a list box for doc_date, or if you add a current selections object. I strongly suggest creating a calendar table with doc_year, doc_month, and whatever else you might need. Use the real fields from the calendar instead of list box expressions.
Thank you john,
how could i create a calendar table?
shlomo
Thank you john,
how could i create a calendar table?
i'm loading my data from sql-server, i can add those fields to my sql server selection (using sql functions) there is a better way?
shlomo