Forum Discussion

klb0066's avatar
klb0066
Frequent Visitor
8 years ago

if statement

Creating a splicer with title "Has Due Date?" with True or False checkboxes. Coded an if statement that recognizes if field was left bank then it is false and if the field has a date it is true.   ...
klb0066's avatar
klb0066
Frequent Visitor
8 years ago

Created this statement for a splicer

 

hasDue = if(ISBLANK(MX_TICKET[TARGETFINISH]),FALSE(),TRUE())

 

Identifies blank entries as false and entries that have a date as true. I want to add and overdue checkbox. How do I relate current date to due dates then pull out over due pieces?