Timestampformat wrong

Hi,

I have an emailnotification and I want to show a timestamp attribute.

So:
BO.Message='The date and time is:' + AS_STRING(BOx.StartDateTime)

The problem is that it shows: 2011-10-15T12:12:00

I do not want the reversed order of yyyy-MM-dd, no 'T' and no seconds.

I want: 15-10-2011 12:12

I tried several typecasts, but cannot get the right format.

Any help here?

Have you tried no casting at all?

Yes I did, the following error occurs:

Operands of addition expression are of incompatible types

I found a (undocumented) solution myself:

You can set the format in the AS_STRING function like this:

BO.Message='The date and time is:' + AS_STRING(BOx.StartDateTime, 'dd-MM-yyyy hh:mm')

This works and for me the problem is solved.