SQLite Dates

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…