Title: ABASE – Date format in WHERE statement
Last modified: August 22, 2016

---

# ABASE – Date format in WHERE statement

 *  [GMRobbins](https://wordpress.org/support/users/gmrobbins/)
 * (@gmrobbins)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/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](https://wordpress.org/support/users/gmrobbins/)
 * (@gmrobbins)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/abase-date-format-in-where-statement/#post-5354309)
 * [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.

 * 1 reply
 * 1 participant
 * Last reply from: [GMRobbins](https://wordpress.org/support/users/gmrobbins/)
 * Last activity: [11 years, 9 months ago](https://wordpress.org/support/topic/abase-date-format-in-where-statement/#post-5354309)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics