Time Parameter

[BlurredVision]

Could someone share with me the best way to strip out the time from a datetime field to be used in a parameter. I am attempting to get the time to be displayed in the following format HH:MMPM within the parameter.

Thanks for your help.

 

[synapsevampire]

You don't need to strip it out at all, place it on the report canvas, right click it and select format field->Datetime->Customize.

You have options to only display the time, with plenty of choices on formatting.

-k

 

[Madawc]

Something like TOtext({Date}, "hh:mm") for the date, and then tack on a formual field that checks the hour and says "AM" or "PM"

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. I use Crystal 8.5

Madawc Williams (East Anglia, UK)

 

[BlurredVision]

Thanks Synapsevampire, but I need the formatting to be done for a parameter. BTW, I am using v10

 

[synapsevampire]

It doesn't matter if it's a parameter, you can still change the formatting.

Perhaps you mean that you want to change the way the parameter is displaying the time?

-k

 

[BlurredVision]

Yeah.. They way the parameter is displaying the time... Sorry about that.