Formula to convert to date 1

[Jimduq]

I have the following formula but keep getting error for 'Then missing'. Please advise where to insert 'Then'

If ({Command.DATA_TYPE_CD}="D" );
FormatDate(ToDate(FormatNumber({Command.BEFORE_VALUE_NO};"000000");"MMddyy"); "dd-MMM-yyyy");
FormatNumber({Command.BEFORE_VALUE_NO};"$#,###.#0"))

 

[IanWaterman]

This is not crystal syntax.

What are you trying to do?

Ian

 

[Madawc]

In Crystal, it would be something like

If ({Command.DATA_TYPE_CD}="D" )
then ToText({Command.BEFORE_VALUE_NO},"MMddyy") & " " &     
ToText({Command.BEFORE_VALUE_NO}, "$#,###.#0")

That may not be quite right, but [HELP] will give you the exact values.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP