Selected data created today

Data Service
1

Hi,

I am trying to run a query to select data that was created today. Have tried curdate() and today() in the REST console but get errors.

Haven’t been able to find a docs or videos to guide me.

Any assistance would be appreciated.

Thanks

2

Hi,

The docs you need are here:

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

Finding records created today can be done by using a where clause. The idea would be to use the “created” column.

Regards,
Mark

3

Hi Mark,

Understood but I do not see a function that refers to today’s date like today() or curdate().

Steve

4

There is a function called “NOW()”. You can use it with other functions to extract any portion of the date

5

Hi,

Got it done.

For reference for anyone else, I used this command

date(columnname) = date(now())

Thanks
Steve

1 Like