CRM Web API: how to query data that current Date between date range

(1) Share

Report

Posted on by Community Member

How I use javascript to call CRM Web API, I would like to query some data that current date between date range. But I cannot to use DateTime.Now() to get current date with javascript, because the date would be local time, it is not safe.

So is there any way can get the Current Date with CRM Web API?

Or is there any way can query data between date range? I tried view, but I cannot find properly condition.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Inogic 703 on at

Like (0)

Report

In javascript to get the current Date use this function – new Date()

For Example-

var currentDate =new Date();

For query data between date range –(Retrieve Accounts which are created between Date 11-01-2017 to 30-03-2017)

https://[organizationUrl]/api/data/v8.2/accounts?$filter=createdon le 2017-03-30 and createdon ge 2017-01-11 &$select=name

If this answered your question, please make sure to Mark this as an Answer.

Thanks!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for replying. But the date get in javascript is local time, I don't want it. I just want to get the current Date of CRM.

Was this reply helpful? Yes No
Verified answer

Leonardo Mizikami 152 on at

Like (0)

Report

You can use this to get the UTC time

var now = new Date();

var now_utc = new Date(now.getUTCFullYear(), now.getUTCMonth(), now.getUTCDate(), now.getUTCHours(), now.getUTCMinutes(), now.getUTCSeconds());

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for replying. But I don't think we can use 'var now = new Date();' to get current date, it is local time of user's PC, it would change if user change his PC time. It is not safe.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

use date without time and pass in below format and recommend to always use UTC.

Below worked for me:

accounts?$filter=modifiedon ge 2018-04-28

Was this reply helpful? Yes No