datetime field rounding issue

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
David_(Guest)
Posts: 20
Joined: Tue Oct 10, 2017 12:44 pm

datetime field rounding issue

Post by David_(Guest) » Thu Nov 04, 2010 4:48 pm

I have a datetime field in a visual foxpro 6.0 table. Using xbase designer, report shows the field with "10/18/2010 03:59 pm"; instead of "10/18/10 04:00:00 PM. Is there a rounding issue? I need it to show 04:00 PM. Thanks.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: datetime field rounding issue

Post by kfleming » Mon Nov 08, 2010 10:15 pm

What is displayed in Foxpro?__Kathleen__R&R Support

David_(Guest)
Posts: 20
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: datetime field rounding issue

Post by David_(Guest) » Tue Nov 09, 2010 8:07 pm

foxpro displays "10/18/10 04:00:00 PM"

David_(Guest)
Posts: 20
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: datetime field rounding issue

Post by David_(Guest) » Thu Nov 11, 2010 6:01 pm

Why is R&R show "03:59 pm" instead of "04:00 pm"? I need to fix this.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: datetime field rounding issue

Post by kfleming » Wed Nov 24, 2010 8:38 am

Can you email the table to me so I can test it here?____Kathleen__R&R Support__livesupport@livewarepub.com

Post Reply