I have written a formula which need to return 'No Call' if no date is present.
IF IsEmpty([Call Date]) THEN "No Call"
ELSE [Call Date]
ENDIF
Although I get an error as 'No Call' is obviously not a data format.
How can I alter the formula or use a different method to achieve the output required?
Thanks
Solved! Go to Solution.
Hi @tf05
Use a select tool and convert it to v_string then it will support like below
Hope this helps : )
Happy to help : ) @tf05
Cheers and have a nice day!
Hi @tf05 ,
I guess, [Call Date] has the data type "Date" or "DateTime", your formula tries to insert a string in this field - of course this is not possible.
An option colud be to create an additional field with a string data type (e.g. V_String) and calculate this new field
IF IsEmpty([Call Date]) THEN
'No Call"
ELSE
DateTimeFormat([CallDate], '%Y-%m-%d')
ENDIF
Drawback is - the new field isn't a date field any longer, you can't perform DateTime functions (e.g. calculate difference in days) without converting it to a date datatype again.
What do you think - could that be a solution?
Best,
Roland