I have implemente a function so my app to show the appointments for the restof the day based in comparison between current time and 23.59.59. Localy the app works but ehen I deploy it tothe Xojo Cloud it is shown all appointments instead of the remainings for today. Do i have to treat it in a special way?
may be you have to deal with timezones ?
The date on all Xojo Cloud servers is set to UTC. it is up to you to convert to the correct time zone.
Do I need to set ???
Dimt today as Date
today.GMTOffSet = Session.GMTOffset
and the to execute the qury SELECT * from XXX Where today BETWEEN iiii AND jjj
you have to use today.sqldate in your query…