We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

query > on day in the future

Development and Programming

hartstikkid's avatar
hartstikkid
4 posts
11 years ago
hartstikkid's avatar hartstikkid

Hello,

Can anyone help me with this little problem. I have a query :

{exp:query sql="SELECT * FROM exp_channel_grid_field_2 WHERE 
col_id_6 > {current_time} ORDER BY col_id_6 ASC;" }

<span class="date">{col_id_6 format="[%d/%m/%Y]"}</span> 


{/exp:query}

in the code above col_id_6 is an event-date, if event date > {current_time) the event is displayed

now i want something to have like : if event date > {current_time + 1 week) (so display the event till current time + one week)

Any advice ???

THX Koen

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.