Support Topics Documentation Slack YouTube Blog

Error in date now with codeless


(zeev mindali) #1

hello to all.

i using the next code block for date:

but in console realtime log i getting the incorrect month (one month before)

Sun Dec 16 2018 17:34:57 GMT+0200 (Israel Standard Time) | SERVER_CODE | INFO | [16525] distance(35.037654709075866,32.79285355860873,lan,lat)<km(0.25) AND isClosed=false AND created before ‘11/16/2018’


(Mark Piller) #2

Months are zero based , I think, that’s why it is one month before


(zeev mindali) #3

strange, so I need to convert it to number and add 1?


(zeev mindali) #4

working :slight_smile:


(zeev mindali) #5

no working :frowning:
I see dates in 12/16/2018
but when I try sql in candle:

created at ‘12/16/2018’

not getting any result


(Mark Piller) #6

https://backendless.com/docs/rest/data_search_with_dates.html


(zeev mindali) #7

figure something out, need to add the hours :frowning:
now start to work