Hi Melissa,
Can you post a screenshot of the record that triggered the error you posted? I created a Formula(DateTime) field and used your Formula and can't get the error to trigger
IF (
CASE (
MOD ( DATEVALUE ( DateTime_1__c ) - DATE ( 1900, 1, 8 ) , 7 ) ,
0 , 1 ,
1 , 1 ,
2 , 1 ,
3 , 1 ,
4 , 1 ,
5 , 0 ,
0
) = 0 ,
DATETIMEVALUE ( TEXT ( DATEVALUE ( DateTime_1__c ) ) & ' 23:00:00' ) +
CASE (
MOD ( DATEVALUE ( DateTime_1__c ) - DATE( 1900, 1, 8 ) , 7 ) ,
0, 1,
1, 1,
2, 1,
3, 1,
4, 3,
5, 2,
1
) ,
DateTime_1__c +
CASE (
MOD ( DATEVALUE ( DateTime_1__c ) - DATE( 1900, 1, 8 ) , 7 ) ,
0, 1,
1, 1,
2, 1,
3, 1,
4, 3,
5, 2,
1
)
)
5 comments
Oh dang that's right you told me that. The PONY! You have to send pics!! Have a blast!! See you dreamforce, I am presenting some breakout sessions!
