Date time restriction to time on current date?

[MartUK]

I am using CR XI

I want to restrict data from the following :

{SP100_ACTIVITIES.EXPECTED_END} >= DateTime (2007, 07, 13, 00, 00, 00)

to more generalised current date from 6:30 am onwards. Can some one help with the code syntax please

 

[Madawc]

Try

{SP100_ACTIVITIES.EXPECTED_END} >= DateTime (Year(Currentdate), Month(Currentdate),  Datepart("d", Currentdate),  6, 30, 00)

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

 

[MartUK]

thanks this works, any idea on the other time diff question I had?