I have written a formula field of data type DATETIME and return type text
IF((ISPICKVAL(Status, 'Completed')),NOW(),'')
but error occurred states
Error: Incorrect parameter type for function 'IF()'. Expected DateTime, received Text
Add a comment
|
1 Answer
return type of your formula field is Text, that is why you have to return Text types in both results: true and false of IF formula. Add TEXT formula for returned NOW()
IF(ISPICKVAL(Status, 'Completed'), TEXT(NOW()), null)
returned result of TEXT(NOW()) is in GMT time
answered Feb 4, 2019 at 13:19
-
I tried it too but got Error: Formula result is data type (DateTime), incompatible with expected data type (Text).– SwathiFeb 4, 2019 at 13:31
-
-
Get rid of the extra parentheses. They seem to be screwing you up too. I think you close your
IFearly.– Adrian Larson ♦Feb 4, 2019 at 13:37 -
Thanks! it worked but the time is getting wrong. Not showing current time– SwathiFeb 4, 2019 at 13:40
-