Hiya, I was wondering if someone could help me. I'm trying to write a report for Symposium using crystal and I'm having a bit of trouble. I'm using the applicationstat fields and I'm trying to get the report to say if it's between 8am and 1pm then do this calculation otherwise do something else. However the timestamp field only seems to be a date. If I use Time({applicationstat.timestamp)>08:00:00 it wants me to put 'then' after the 8 and if I use hour({applicationstat.timestamp)>08 it doesn't seem to recognise it. I've also tried using the time field but again I get problems. If I use Hour({applicationstat.time}) it says a date is required here and if I use Time({applicationstat.time}) it says not enough arguments have been given to this function.
I'm sure it must be something simple that I'm missing -please help before I go bald!

I might be able to help if you could tell me a couple of things:

What version of Crystal you're using? (String conversion is slightly different above V8 - and I think this might be the problem)
What's the exact field type of timestamp? (Which you'll need to know to pick the correct function)

Just out of interest, does anyone know what database Symposium runs?

Regards,
Darryl
www.darrylbeckford.co.uk

It's optional as far as I know.

Oracle or SQL server seem to be the two main.

Crystal YUK...

HTH

DaveA

If you don't know how to find out the data type of time stamp, then you could try a bit of trial and error. I'm assuming that it is datetime, but Crystal has two different datetime formats.

If it's a "date time string" try this:

DTStoTime({applicationstat.timestamp})>Time(8,0,0)

If it's just a "date time" try this:

DateTimeToTime({applicationstat.timestamp})>Time(8,0,0)

Each time we're converting it to a time field, and then comparing it against a time field of the same data type that we've just created with time().

Can you let me know how you get on?

Regards,
Darryl
www.darrylbeckford.co.uk

Thanks for your suggestions. I gave them a go but I still got error messages - probably the result of an old version of symposium and an old version of Crystal. Anyway, I've managed to find a way round it using the formula below. Thanks again,
numbervar HHour;
numbervar MMinutes;
numbervar SSeconds;

HHour := ToNumber({ApplicationStat.Time}[1 to 2]);
MMinutes := ToNumber({ApplicationStat.Time}[4 to 5]);

Time(HHour, MMinutes, SSeconds);