Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom Column If condition

Hi,

I got error after typing this statement.

if(date([Deadline])<=date([Date of extratime]) then date( [Date of extratime]) else date([Deadline]))

Any help on this?

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , do not use the first parenthesis "(" after if; and one at end ")"

    try like

    if [deadline] < [date of execution] then date[deadline] else [date of execution]  

     

    Change columns as per need

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , do not use the first parenthesis "(" after if; and one at end ")"

    try like

    if [deadline] < [date of execution] then date[deadline] else [date of execution]  

     

    Change columns as per need