what formulas should be put for the date by sequence in crystal report?

Question

There is an error message shown up for when I edit the formulas. we want to sort the ship date by sequence.

parameter field

error message for "A date-time is required here"

Answer 1

If then else must return the same data type for all branches.

So Convert the dates to a string. For example, ToText({Ship_Date}, 'yyyyMMdd') and convert the numbers to a string as well. For example, ToText({PartN}, 0, "")

Answer 2

ToText {CUST_ORDER_LINE.PART_ID} is missing ()

Need to be ToText({CUST_ORDER_LINE.PART_ID},0,"")