ShowAll Questionssorted byDate Posted
Danny Hartley

# Help with this formula

I was wondering if anyone could tell me why this formula is not working?  Thanks in advance.

IF(
OR(
AND (
VALUE( MID(TEXT( CreatedDate ), 12, 2))  >= 17,
VALUE( MID(TEXT( CreatedDate ), 12, 2))  <= 7
),
IF(MOD(DATEVALUE( CreatedDate ) -  DATE(1900,1,7),7) = 0, true, false),
IF(MOD(DATEVALUE( CreatedDate ) -  DATE(1900,1,7),7) = 6, true, false)
)
true, false
)
Best Answer chosen by Danny Hartley
Malni Chandrasekaran 2
Danny,

IF(
OR(
AND (
VALUE( MID(TEXT( CreatedDate ), 12, 2))  >= 17,
VALUE( MID(TEXT( CreatedDate ), 12, 2))  <= 7
),
IF(MOD(DATEVALUE( CreatedDate ) -  DATE(1900,1,7),7) = 0, true, false),
IF(MOD(DATEVALUE( CreatedDate ) -  DATE(1900,1,7),7) = 6, true, false)
),                                              //This comma was missing
true, false
)

Danny Hartley
This is the error I am receiving.  Also, the point of the field is to mark a checkbox true if the time is after 5pm or anytime on Saturday or Sunday.  Thanks.
Danny Hartley
Error: Syntax error. Missing ')'
Malni Chandrasekaran 2
Danny,