How do I Create a Column using "IF" and "Contains"
Hello,
I have a date and time column with "AM" and "PM" in the format.
Using JSL, I wand to add a new column that will indicate it its a day or night.
Row with "PM" in the date will input "Day"
Row with "AM" in the date will input "Night"
I try using the following:
For( i = 1, i <= N Rows( dt ), i++,
If( Contains( :Date[i], "PM" ) ,
:Day/Night[i] = :Day[i]
)
But it wont work.
Thanks in ad...