Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Claushingebjerg 886 posts 2415 karma points
    Mar 14, 2019 @ 09:11
    Claushingebjerg
    0

    Error in query builder when using dates

    Just tried the built in query builder to list some pages where the publish date is greater than some date, and it fails out of the box... Whats the right syntax?

    enter image description here

    enter image description here

    Copy Link
  • Bjarne Fyrstenborg 1182 posts 3441 karma points MVP 4x c-trib
    Mar 14, 2019 @ 12:34
    Bjarne Fyrstenborg
    100

    The value you compare the CreateDate with doesn't seem to be in correct format as 3/6/2019 12:00:00 AM or "3/6/2019 12:00:00 AM".

    You need to convert/parse this to a DateTimeobject, e.g.

    .Where(x.CreateDate >= new DateTime(2019, 3, 6, 12, 0, 0));

    or

    .Where(x.CreateDate >= DateTime.Parse("yyyy-MM-dd HH:mm:ss"));

    where yyyy-MM-dd HH:mm:ss is your date time format.

    Copy Link
  • Claushingebjerg 886 posts 2415 karma points
    Mar 22, 2019 @ 06:59
    Claushingebjerg
    0

    I ended up with

    var now = DateTime.Now;
var eventtimeclean = item.Value<DateTime>("eventdato");
if (eventtimeclean > now) { 
 (my stuff)
}
    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies