time frame

[mhill31]

Is there a function that works like WeekDay() for time frames. I have a date field that includes time. I would like a field that returns one number for all times between 1AM and 2AM then a different number for all times between 2AM and 3AM. So if the date field included the time 2:04 AM then a 2 would return in the time frame field.

In case this will help, what I'm trying to do is a sales analysis by time of day on eBay. This will help me to better know the best times for listings. eBay provides times of sales down to the second so I obviously can't sort by that. I would like to assign one number to all sales within a single hour.

Thank you for your help.

 

[Mile-O]

Hour()

 

[Brianwarnock]

Hi

Will the Hour Function provide what you want?

Hour(fldDate) will return the hour in the Date/Time field fldDate.

Brian

 

[Brianwarnock]

Guess Mile-O-Phile beat me by seconds, appropriate on a time question

brian

 

[mhill31]

Fantastic! Thanks so much. I was guessing all kinds of words but obviously never thought of that one. Help from all is much appreciated!