Month and Year functions

[m4u]

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

[parpatra]

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,

[johnw]

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.

[m4u]

Thank you john,

how could i create a calendar table?

shlomo

[m4u]

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

[Miguel_Angel_Baeyens]

Hello Shlomo,

Use the information and code examples in this post.

Hope this helps.