if else condition in RRDI query
![]()
Naveen Chandani (48●1●20●22)
| asked Jul 01 '12, 1:08 a.m.
edited Nov 28 '13, 2:36 a.m. by Krzysztof Kaźmierczyk (7.4k●3●54●99)
I have 2 columns in a query in RRDI (column a & column b). i want to insert a data item with the if else condition. The condition is if the value in column a is equal to column b then print no change else print the value of column a itself. Can you please help me with the syntax of this if else condition.I am facing difficulty with the else statement. It is not allowing me to print the value of column a. However if I enter some string over there, it works fine.
|
2 answers
![]()
Try this
if ([Creation Date] > '01/01/2012') then ('01/01/2012') else ([Creation Date]) make sure that the date printed is a valid date |