ABASE – Date format in WHERE statement

  • Date format has me perplexed.

    [abase table=”events” columns=”event_name,city,state,start_date” where=”AND start_date = ‘today'” ORDER=”start_date DESC” LIMIT=15]

    What I would like to show is the next 15 events after “today”! Any assistance would be appreciated!

Viewing 1 replies (of 1 total)
  • Thread Starter GMRobbins

    (@gmrobbins)

    [abase table=”events” columns=”event_name,city,state,start_date” where=”AND start_date >= ‘2014/10/1′” ORDER=”start_date ASC” LIMIT=10]

    The above works! But the real question is how to make the date “2014/10/1” a variable so that it’s always the current date?

Viewing 1 replies (of 1 total)
  • The topic ‘ABASE – Date format in WHERE statement’ is closed to new replies.