How to fix a parse error on business day formula

hello, I'm trying to calculate business day and using the formula below =. I'm receiving Parse Error

IIF([Application_Date_Regulatory]>[Appraisal_Sent_To_Applicant_Date],
Null(),
1 +
((DateTimeDiff([Appraisal_Sent_To_Applicant_Date],[Application_Date_Regulatory],"days")*5 - ([App Date]-[Sent Date])*2) / 7) +
IIF([Sent Date]==6,-1,0) +
IIF([App Date]==0,-1,0)
)

any help with what I'm doing wrong here? Thanks in advance

Parse

Accepted answers

binu_acs

@CRogers22 Make sure all your Date fields are Date data type. I am guessing the App Date field and Sent Date field are Date data type

IF([Application_Date_Regulatory] > [Appraisal_Sent_To_Applicant_Date],
    Null(),
    1 +
    ((DateTimeDiff([Appraisal_Sent_To_Applicant_Date], [Application_Date_Regulatory], "days") * 5 - 
    (DateTimeDiff([App Date], [Sent Date], "days") * 2)) / 7) +
    IIF(toNumber(DateTimeFormat([Sent Date],'%w')) == 6, -1, 0) +
    IIF(toNumber(DateTimeFormat([App Date],'%w')) == 0, -1, 0)
)

All comments

binu_acs

@CRogers22 Make sure all your Date fields are Date data type. I am guessing the App Date field and Sent Date field are Date data type

IF([Application_Date_Regulatory] > [Appraisal_Sent_To_Applicant_Date],
    Null(),
    1 +
    ((DateTimeDiff([Appraisal_Sent_To_Applicant_Date], [Application_Date_Regulatory], "days") * 5 - 
    (DateTimeDiff([App Date], [Sent Date], "days") * 2)) / 7) +
    IIF(toNumber(DateTimeFormat([Sent Date],'%w')) == 6, -1, 0) +
    IIF(toNumber(DateTimeFormat([App Date],'%w')) == 0, -1, 0)
)

ChrisTX

Can you post a workflow including sample data? The data types are important here, and we can't determine which data type each field is.

For example: is [Sent Date] a Date data type? If yes, you can't use [Sent Date]==6. You would need to convert [Sent Date] to a day of the week, and use an Integer data type.

Chris

CRogers22

Thank you both. easy fix.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703