Q:

Crystal Report Date Format Error

Can anyone tell me why I'm getting a bad date time format exception on the following:
Cstr({invsp_SelectOrderWithClient;1.dtLabel1}) + " at " 
  +  ToText(CDate({invsp_SelectOrderWithClient;1.dtLabel1}), "HH:mm") 

The Exception is just a generic

Bad Date Format string.
  Details.errorkind

Not very helpful, It doesn't have anything more specific, however it is pretty generic thanks in advance.

A:

Your approach is wrong....you are converting to date but extracting time part from the value.
Instead try like this.
Cstr({invsp_SelectOrderWithClient;1.dtLabel1}) + " at " 
  +  ToText(CDateTime({invsp_SelectOrderWithClient;1.dtLabel1}), "HH:mm") 

