Extracting time from date time

[rgibson975]

I have a date time field from an input clock with the following format record one 1/18/09 9:51am record two 1/18/09 3:30pm.

I want to two categories Breakfast_Lunch clock-in time earlier than 3:00pm and Dinner clock-in time later than or equal to 3:00

How do I strip out the Date portion so I can work with the time only?

thanks in advance for your help.

ron

 

[Madawc]

Try something like

DatePart ("h", {your.date1})

This will give you the hour: you can get the minute using "n".

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

 

[kskid]

if Time({table.date}) < time(15,0,0) then
"Breakfast-Lunch"
else
"Dinner