In Formula, Convert date to string data types

[kamkaro]

Hi All,
Please give me your expert suggestions, when I am creating the formula, getting the following error.

Function:
if {?Start_date} = '' then {Command.LAST_MONTH_ST_DT} else {?Start_date}

Error:
A date Time Required Here for {Command.LAST_MONTH_ST_DT} .

Where:
{?Start_date} is String datatype
{Command.LAST_MONTH_ST_DT} is Date datatype

How do I convert Date ({Command.LAST_MONTH_ST_DT})data type to string in formula editor?

Thanks.

 

[kray4660]

ToText works pretty good for most cases.

 

[xxyyzz49]

If the parameter is a string representing a date time date type and is optional

if hasvalue({?Start_date}) and isdatetime({?Start_date})
then  datetime({?Start_date} )
else {Command.LAST_MONTH_ST_DT}  // assuming the database is returning a date time from the original post