×

info

Dear guests,
You are currently on the old forum we kept as a knowledge base. You will find the new community forum here
Welcome, Guest
Username: Password: Remember me
Keyword

TOPIC: Filter on a date

Filter on a date 10 years 8 months ago #2948

  • Anonymous user
  • dutch_photographer's Avatar
  • Posts: 2
  • Karma: 0
Managing Lists seems real easy using filters.
I want to filter all users who haven't logged in for the last 3 weeks. How can I manage this?
  1. Set Filter on Joomla User Field
  2. Field is lastvisitDate
  3. ...

The data is in a text format (like "07 February 2010", so dealing with < or > will not work here.

What is the solution?

Thanks in advance
Please log in to post a reply

Re:Filter on a date 10 years 8 months ago #2949

  • Anonymous user
  • john's Avatar
  • Posts: 10494
  • Thank you received: 2
  • Karma: 242
The format for "registerDate" and "lastvisitDate" is YYYY-MM-DD (example: 2010-02-06 22:06:49)
So lastvisitDate < 2010-01-17 should do the job!
Please have a look at our official documentation before posting a new message!

If you use AcyMailing, please post a rating and a review at the Joomla! Extensions Directory.
Please log in to post a reply

Re:Filter on a date 10 years 8 months ago #2952

  • Anonymous user
  • dutch_photographer's Avatar
  • Posts: 2
  • Karma: 0
Hi John,

Yes, that really worked!! I'm glad.
Thanks for the quick support,

Sjoerd
Please log in to post a reply
Time to create page: 0.056 seconds
Powered by Kunena Forum