CASE with text and if Date 1

[rwn]

This is the Case statement that I'm using and then having it do a Group Sort.

Formula Name = @GroupSort
Select {@OptSortBy}
Case 1: {SF_ProductionOverview_TTX.Job}
Case 2: {Delivery.Promised_Date}
Case 3: {SF_ProductionOverview_TTX.Customer_PO}

But, the error message indicates the the xxx.customerPO "A Date is Required here

 

[briangriffin]

All conditions of a case statement, or if..then statement, must return the same datatype. It looks like you're returning two numbers and a date (unless the PO and Job fields are text).

In this example, you'll have to convert all the fields to text, such as:

totext(delivery.promised_date)

Check out CR help on totext to see examples of the different format strings you can include to display dates and numbers in the format you want.

 

[rwn]

I tried that first with this:
Select {@OptSortBy}
Case 1: {SF_ProductionOverview_TTX.Job}
Case 2: cstr({Delivery.Promised_Date})
Case 3: {SF_ProductionOverview_TTX.Customer_PO}

It doesn't sort by the true date then.

 

[briangriffin]

Then you'll need to convert to a format such as 20100910 that will sort properly:

totext(promised_date,"yyyyMMdd")

Then use a formula in the Customize Group Name area of the Change Group dialog in order to display it in the format that you really want to see it.

 

[rwn]

thank you. i will try later. is there a way to set the text date to asending sort order?

 

[briangriffin]

The 20100912 format will sort ascending, unless you tell CR otherwise.