how can return formula field as Date/Time

Question

I want to use this formula field in workflow rule time trigger but i am getting error-

Error:

Formula result is data type (Text), incompatible with expected data type (Date/Time).

formula field code is below.

IF(ISPICKVAL(Priority_Time__c, "P1"),  Now()- 0.03109,  

IF(ISPICKVAL(Priority_Time__c, "P2"),Now()- 0.03800), 

"false"  )  )

"false" is not a Date/Time, you need to fix your FALSE scenario and return null or another valid Date/Time — Boris Bachovski, Jul 4 '17 at 5:54
Hi Bachovski, Whether i am returning null than also got same error Error: Formula result is data type (Text), incompatible with expected data type (Date/Time). — Md Parwej, Jul 4 '17 at 5:57
Try this IF(ISPICKVAL(Priority_Time__c, "P1"), Now() - 0.03109, IF(ISPICKVAL(Priority_Time__c, "P2"), Now() - 0.03800, null), null) — Boris Bachovski, Jul 4 '17 at 5:58
If condition will be true than return Date/Time.If false than it should also return flase in Date/Time type — Md Parwej, Jul 4 '17 at 6:00

night crawler · Accepted Answer · 2017-07-04 06:46:50Z

0

This should work

> IF(ISPICKVAL(Priority_Time__c, "P1"), Now() - 0.03109,
> IF(ISPICKVAL(Priority_Time__c, "P2"), Now() - 0.03800, null))

answered Jul 4 '17 at 6:46

night crawler

7524 silver badges13 bronze badges

Hi Night Your above solution is working Thanks Night – Md Parwej Jul 4 '17 at 7:03

add a comment |

1 Answer 1