Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Dynamic Web Charts › Date Order Issue and Dynamic Dates...

Date Order Issue and Dynamic Dates...

Thread began 12/08/2010 10:34 am by iamdan356160 | Last modified 12/14/2010 9:37 am by iamdan356160 | 3503 views | 9 replies

12/08/2010 10:34 amiamdan356160

Date Order Issue and Dynamic Dates...

Hi all,
I have 2 quick questions...

Number 1 - Date Order Issue...
I have a field in my database named 'User_JoinDate' and the date is being written in the following format yyyy-mm-dd. For some reason, when the dates are displayed in the chart generated by DWC, they appear in the following order...
Dec 5,2010
Dec 6,2010
Dec 7,2010
Dec 8,2010
Dec 2,2010
Dec 3,2010

Any ideas why the dates are not ordering them self correctly?

Number 2 - Adding dynamic dates to mySQL statement...
Currently my SQL statement looks like this...

WHERE User_JoinDate >= '2010-12-02' AND User_JoinDate <= '2010-12-08' AND User_AccountType = 'free'

How can I write this statement so that the dates are not hard coded? For example... the 'Date From' to be dynamically written to 7 days ago from today's date and the 'To Date' dynamically written to be today's date? Does that make sense?

Any help would be greatly appreciated! Thanks in advance!

Dan

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.