11-15-2016 09:54 AM
I am trying to add "datepart" to my date field in Information Map Studio and am getting an error when validating.
case when <<datepart(ZW_CURRENT_DATE_DIM.CALENDAR_DATE)>> > '08Nov2016'd then '2nd Quarter'
11-15-2016 10:27 AM
Well, never used information map, so apologies if this is not the item, but why do you have << and >> around the datepart function? Also, it may help if you actual post a picture ot the text of what the "error" is, perhaps that isn't a date variable?
11-16-2016 04:21 AM
Why have you marked the post containing your error as the solution? Also, please post the erro as either text or picture in the post, I would not download any Office files.
The syntax of a case statement is:
case when <condition> then <result> [when...] else <result> end
case <variable> when <value> then <result> [when...] else <result> end
As I say, never heard of this information map, but I have never seen any system using << >> around variables, that is an operator in some languages.
Need further help from the community? Please ask a new question.