jan pieter
Registered User.
- Local time
- Today, 11:03
- Joined
- Dec 28, 2013
- Messages
- 15
I have had this problem for a few hours and I can't figure it out 
I'm trying to filter out a report by year, but the value i'm trying to filter is a datetime value and it just doesn't whant to work.
I tried to make a separate unbound text field to filter out the Datetime into year and then filter that field out with year but it doesn't work.
What I did:
I clicked on the control element of the unbound text field.
made a expression with this code : datepart ("YYYY", [BeginDatetime])
(BeginDateTime is a table value)
After this one it keeps showing me this error :
"the syntax of the expression You've taken specified is invalid"
some help would be appreciated.
I'm trying to filter out a report by year, but the value i'm trying to filter is a datetime value and it just doesn't whant to work.
I tried to make a separate unbound text field to filter out the Datetime into year and then filter that field out with year but it doesn't work.
What I did:
I clicked on the control element of the unbound text field.
made a expression with this code : datepart ("YYYY", [BeginDatetime])
(BeginDateTime is a table value)
After this one it keeps showing me this error :
"the syntax of the expression You've taken specified is invalid"
some help would be appreciated.
