• From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Topic: hello every one

how can i set Fromdate and Fromtime values Equal to my last stored ToDateTime( in database) on Form Show?

Post's attachments

Attachment icon test.zip 336.84 kb, 297 downloads since 2019-02-02 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,675

Re: hello every one

Hi Raheel,
I'd do it like this (see attached) but there's probably other ways too that might be better.
Derek

Post's attachments

Attachment icon test 2.zip 338.95 kb, 264 downloads since 2019-02-02 

  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Re: hello every one

thanks derek...
its not working.. i need datetime in same column..  and here i fount this error

Post's attachments

Attachment icon untitled.zip 33.54 kb, 261 downloads since 2019-02-02 

4 Reply by derek (edited by derek 2019-02-02 23:12:53)

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,675

Re: hello every one

The error you encountered was because you hold your dates in a different format.
I tried using separate date and time fields because your datetime fields were not set up correctly in your original 'test' application (see screenshot in the attachment). 
As you need date and time in the same column, I've corrected this and everything looks okay at my end.

Post's attachments

Attachment icon test3.zip 450.66 kb, 275 downloads since 2019-02-02 

  • From: Gotham City
  • Registered: 2017-12-31
  • Posts: 406

Re: hello every one

thanks derek... now its working.. good job..