Susan Harkins
ssharkins at bellsouth.net
Wed Nov 19 13:54:24 CST 2003
Right -- shouldn't one of your options be 12/29/1899 11:00 PM?
Susan H.
> Why would it return any of those values, Gustav? Since the date is
> implied, removing 3 hours from it is going to kick it into the previous
> day.
>
> Charlotte Foust
>
> -----Original Message-----
> From: Gustav Brock [mailto:gustav at cactus.dk]
> Sent: Wednesday, November 19, 2003 9:40 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Pop-quiz: DateAdd() and negative time values
>
>
> Boring day.
> So here's a quick quiz to wake you up.
>
> The time value of #02:00 AM# equals
>
> 12/30/1899 02:00 AM
>
> What does - off your head - this expression return:
>
> ? Format(DateAdd("h", -3, #02:00 AM#),"mm\/dd\/yyyy hh\:nn AM/PM")
>
> a) 12/30/1898 11:00 PM
> b) 12/30/1899 01:00 AM
> c) 12/30/1899 05:00 AM
> d) 12/30/1899 05:00 PM
> e) 12/30/1899 11:00 PM
>
> The tricky part is DateAdd(). Format(), it is only for ensuring a
> consistent format of the return value.
>
> Morale: Be careful with negative time values.
>
> /gustav
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>