Stop datetime formula from showing time

[leightur]

I know this can be achieved in the main report by:

File / Options / Fields Date and Time however the time still shows when the report is run in a Crystal runtime.

here is my formula:

if {CARDS.DUE_DATE} = Datetime (1753, 01, 01, 00, 00, 00) or {?Show delivery date} = "No" then {@qty}

else {CARDS.DUE_DATE} & " " + {@qty}

Returns 30/01/2008 00:00:00
Would like to return just date.

Thanks,

Leigh

 

[Madawc]

Try ToText({CARDS.DUE_DATE}, "dd/MM/yyyy"). You could probably also do it with Date({CARDS.DUE_DATE}), but ToText has a lot of interesting options.

You can also get rid of the time display from all fields using File > Options > Fields and adjusting the date-time display.

It also helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10