Javascript CAML Query using DateTime

Question

I have the following CAML:

<Where>
    <And>
        <Eq>
            <FieldRef Name='Author' LookupId='TRUE' />
            <Value Type='User'>473</Value>
        </Eq>
        <Eq>
            <FieldRef Name='Datum' />
            <Value Type='DateTime'>2015-06-05T00:00:00Z</Value>
        </Eq>
    </And>
</Where>

In my list I have 8 items, 7 of these have Author equals 473 and 2 of these have Datum equals 2015-06-05. Whatever value I pass to the Datum i always get 7 items. What is wrong?

Are you certain that Datum is the internal name of the column? Otherwise it looks correct. — Eric Alexander
– Eric Alexander, Commented Jun 5, 2015 at 14:35
try this one <Value IncludeTimeValue='TRUE' Type='DateTime'>2015-06-05T00:00:00</Value> — Waqas Sarwar MVP
– Waqas Sarwar MVP ♦, Commented Jun 5, 2015 at 14:49
Nope. The curious thing is that I get 7 items....if the passed date value isn't correct, I should get 0 items. Right? — Emaborsa
– Emaborsa, Commented Jun 5, 2015 at 14:51
It tends to ignore the CAML if the field values aren't correct rather than throwing any error. I'd try downloading the BIWUG CAML Designer and see what it spits out after constructing the query. biwug.be/resources — Eric Alexander
– Eric Alexander, Commented Jun 5, 2015 at 15:00

Emaborsa · Accepted Answer · 2015-06-08 06:22:11Z

1

I wasn't able to find out the problem, but with the following workaround I got it:

<Where>
<And>
    <Eq>
        <FieldRef Name='Author' LookupId='TRUE' />
        <Value Type='User'>473</Value>
    </Eq>
    <And>
        <Leq>
            <FieldRef Name='Datum' />
            <Value Type='DateTime'>2015-06-05 00:00:00</Value>
        </Leq>
        <Geq>
            <FieldRef Name='Datum' />
            <Value Type='DateTime'>2015-06-05 00:00:00</Value>
        </Geq>
    </And>
</And>

answered Jun 8, 2015 at 6:22

Emaborsa

1,1991 gold badge11 silver badges35 bronze badges

Add a comment |

ECM4D · Accepted Answer · 2015-06-05 19:06:11Z

0

Please check the time zone of your server. It is possible that your web time zone and browser time zone differs. You should try these options:

Set property SP.CamlQuery.datesInUtc to false
Set property SP.CamlQuery.datesInUtc to true and pass correct value in UTC. For example, if your web time zone is +2 UTC, browser shows date value 2015-06-05 00:00:00, but real value in SharePoint database is 2015-06-04 22:00:00

Play with this settings and values.

answered Jun 5, 2015 at 19:06

ECM4D

1,96212 silver badges24 bronze badges

I tryied it out, but the result does not change.

Emaborsa
– Emaborsa

2015-06-08 06:18:12 +00:00
Commented Jun 8, 2015 at 6:18

Add a comment |

Altynbek S. · Accepted Answer · 2021-10-17 15:31:02Z

0

You can use LocalTime to UTC convertion. Example in pnp js:

const yourDateTime = new Date();
const timezone = sp.web.regionalSettings.timeZone;
const dateTimeForCaml = (await timezone.localTimeToUTC(yourDateTime)).toString();

Its solve my issue even when I have time zone differences with SharePoint.

answered Oct 17, 2021 at 15:31

Altynbek S.

263 bronze badges

Add a comment |

Stack Exchange Network

Javascript CAML Query using DateTime

3 Answers 3

Your Answer

Hot Network Questions

Javascript CAML Query using DateTime

3 Answers 3

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions