Skip to main content
Topics#Data ManagementDeanne Walters's Question
Deanne Walters (LifeStation) asked in #Data Management
Nov 9, 2018, 6:39 PM

Extra "," in IF formula

I have this formula, but I keep getting the Extra "," syntax error. Any ideas why?

 

IF(  

 

Date_of_Class__c > 11/4/2018,

 

VALUE( MID( TEXT(  Date_and_Time_from_FormTitan__c  - (0.0417 * 5) ), 12, 2 ) )),

 

VALUE( MID( TEXT(  Date_and_Time_from_FormTitan__c  - (0.0417 * 4) ), 12, 2 ) )))
2 answers
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    Nov 9, 2018, 6:40 PM

    Try this = 

    IF(  
        Date_of_Class__c > DATE(2018, 11, 04),
        VALUE(MID(TEXT(Date_and_Time_from_FormTitan__c  - (0.0417 * 5)), 12, 2)),
        VALUE(MID(TEXT(Date_and_Time_from_FormTitan__c  - (0.0417 * 4)), 12, 2))
    )
Write an answer...
0/9000