"Text" is not a valid Date in Formula Tool

[tf05]

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

[atcodedog05 · Accepted solution]

Hi @tf05 

Use a select tool and convert it to v_string then it will support like below

Hope this helps : )

[atcodedog05]

Happy to help : ) @tf05 

Cheers and have a nice day!

[RolandSchubert · Accepted solution]

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