Hello experts, in universe designer 3.01 i’m trying to bild a predefined filter to prompt users to select month or year for grouping the data by year and month.
In my table the date entry is between 1900-01-01 and 2999-01-01 and my DB is mysql_5.0. I would like to retrieve alle the activities which were planed
in 2009-01-01. In universe designer I can create a prompt object to subtract year and month, for instance:
Month(@Select(activity_dates\date prompt)) -> '01'
Year(@Select(activity_dates\date prompt)) -> '2009'
I would like to extract year and month (2009-01) that i’m sure it is not 1900-01 or 1901-01.
I don’t have much experience with designer so I would appreciate any help.
Thanks
lamso (BOB member since 2008-04-03)