tbsweet52 Posted January 11, 2013 Share Posted January 11, 2013 Hey guys, I was wondering how to show a certain message (or products) to clients based on their signup date. Basically, we are making changes to our order form in which the client must accept new terms and fill in some custom fields ONLY if they have signed up before a certain date. Is this possible, if so how? Thanks! Tom 0 Quote Link to comment Share on other sites More sharing options...
tbsweet52 Posted January 14, 2013 Author Share Posted January 14, 2013 Any one have an answer? 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted January 14, 2013 Share Posted January 14, 2013 Sure it's possible. Use ClientAreaRegister action hook and with MySQL DATEDIFF statement you can get what you want. 0 Quote Link to comment Share on other sites More sharing options...
tbsweet52 Posted January 15, 2013 Author Share Posted January 15, 2013 Thanks for the reply, but to be honest Im a newbie what it comes to that stuff. Any way you can help me out? It'd be greatly appreciated. Thanks! Tom 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted January 15, 2013 Share Posted January 15, 2013 I don't know if you are familiar with action hooks. For now i suppose that you can make the hook. This is the query. SELECT DATEDIFF(DATE(datecreated),'2013-01-01') AS difference FROM tblclients WHERE DATEDIFF(DATE(datecreated),'2013-01-01') >= '0' ORDER BY difference ASC With this i get all clients who have registered starting from january 1 2013. I've also made an element (difference) you can use to get the difference (in days) between the two dates. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.