I'm disapointed around problems of fct datetime:)
I have a datetime column and I want to display the time period of the days in a datagrid:
For exemple :
H1 = Monday to Friday, from 06:00:00 to 21:59:59
H2 = Monday to Friday, from 22:00:00 to 05:59:59
H3 = Saturday from 6:00:00 to 14:00:00
H4 = The rest of time
In fact, "07/08/2009 06:00:01" must return to my dategrid "H1"
It is now 3 days that I have tested all the possibilities to work around this and never get there.
Finally, is it possible please?
A big thank you for your help and sorry for my bad Englsh.