Date/Time entered to be set value of previous date

[YNWA]

Hi,

I have a client who requires a query/report, that when a start and end date are entered they look at specific times.

Eg. When they enter 20/01/2013 they actually want the report to look at everything up until 18:00:00 on 19/01/2013 then when they enter the end date of say 16/02/2013, that it actually looks at everything up until 17:59:59 on 16/02/2013.

Can this be implemented?

Thanks

 

[James Dudden]

Yes as follows:

For the first one it would be <= DateAdd ("h", -6, DateA)

For the second it would be < DateAdd ("h", 18, DateB)

NB: DateA and DateB would need to be replaced with your inputted dates.

One other thing for the first one ddid you meqan this is UP TO or should it be FROM. If from tehn the first one would be >= DateAdd ("h", -6, DateA)

 

[YNWA]

Yes as follows:

For the first one it would be <= DateAdd ("h", -6, DateA)

For the second it would be < DateAdd ("h", 18, DateB)

NB: DateA and DateB would need to be replaced with your inputted dates.

One other thing for the first one ddid you meqan this is UP TO or should it be FROM. If from tehn the first one would be >= DateAdd ("h", -6, DateA)

Sorry I have confused myself.

Start date if entered 02/01/2013 then everything from and including 18:00:00 the day before (so 18:00:00 01/01/2013).

End date if entered 04/01/2013 then everything up to and including 17:59:59 of the 04/01/2013.

Thanks.

 

[James Dudden]

Start date if entered 02/01/2013 then everything from and including 18:00:00 the day before (so 18:00:00 01/01/2013).

>= DateAdd ("h", -6, DateA)

End date if entered 04/01/2013 then everything up to and including 17:59:59 of the 04/01/2013.

< DateAdd ("h", 18, DateB)