R – Crystal Report Formula for Date Separate

If you have a way of parsing the memo field to separate the date and time out, then you can use the DateTime(date, time) function to combine them together into a date time. Then you should be able to use the CSTR or TOTEXT function to put the datetime in the format that you want.

Something like this should work (or be close to working haha)

CSTR(DateTime({datefield},{timefield}), "dddd, MMMM d, yyyy")

You're attempting to return a date in a selection formula (Whether it is a Record, Group, or Saved Data selection formula) and CR doesn't know how to handle that situation. It must be a boolean because selection formulas essentially tell the report to only include data where the formula evaluates to TRUE.

This is like asking, "What do you want on your pizza?" and getting the response "December 7th!" Crystal Reports is asking what data you want to include in the report (via selection formula) and you're responding "December 7th". If you want that date to be useful as selection criteria, you have to use it via a boolean statement like {transactions.date} < dt. Now the report would include all transactions prior to the date you have just computed.