Using date_recorded in a filter

  • lcp298

    (@lcp298)


    1 year, 4 months ago

    I’m having trouble using date_recorded in a shortcode filter. I am using pdb_total to show the number of records added in each month, I’d like a list of at least the past 12 months.

    It works fine with any user added dates, and I do understand that date_recorded comes from the server and is a timestamp rather than just a date, which is presumably where the problem is, I can’t get the format for the dates.

    I’ve tried variations of “date_recorded>=jan 1 2025&date_recorded<feb 1 2025” (also 1 jan 2025 as I’m not in the USA, which also works with other date fields). Tried adding 00:00, 0:00am and always get 0.

    Any idea how I can get this to work, or if I can do something as simple as date_recorded= jan 2025?

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author xnau webdesign

    (@xnau)

    1 year, 4 months ago

    Thanks for bringing this to my attention: it looks like filtering against internal timestamps isn’t working, so this is something I will need to fix.

    I’m sorry for the inconvenience, it will take me several days to a week to get an update out on this.

    Thread Starter lcp298

    (@lcp298)

    1 year, 4 months ago

    No problem, at least I’m not going mad!
    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Using date_recorded in a filter’ is closed to new replies.