|
|
|
Forum Member
 
Group: Forum Members
Last Login: 11/20/2008 12:09:06 AM
Posts: 37,
Visits: 138
|
|
hi everyone! this is just a simple question...hope someone will help me...hehe
my x-axis display dates, but it appears with the time also..
eg: 1995-03-01 00:00:00
how to make it hide the time? in my database, I did not specify the time, just the date. Thanks.
|
|
|
|
|
Supreme Being
Group: Moderators
Last Login: Today @ 11:14:02 PM
Posts: 627,
Visits: 1,914
|
|
Hi
When you retrieve data from SQL Query that time you can format the date value or when you plot in chart that time you have to manually format the date value.
Thanks,
Arindam FusionCharts Team
www.fusioncharts.com
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/20/2008 12:09:06 AM
Posts: 37,
Visits: 138
|
|
thanks for the reply...
but how do you format the date? can you give some example code? sorry, i'm a total newbie...
|
|
|
|
|
Supreme Being
Group: Moderators
Last Login: Today @ 11:14:02 PM
Posts: 627,
Visits: 1,914
|
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/20/2008 12:09:06 AM
Posts: 37,
Visits: 138
|
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/20/2008 12:09:06 AM
Posts: 37,
Visits: 138
|
|
hello??? anybody got any ideas??? help me please....
|
|
|
|
|
Supreme Being
Group: Moderators
Last Login: Today @ 11:14:02 PM
Posts: 627,
Visits: 1,914
|
|
| hi, could you please use this type of sql query For MsAccess Database only SELECT Quantity, format(datepro,"dd/MM/yyyy") AS mydate FROM Factory_Output; here sql query format the date to dd/mm/yyyy format. you can use custom format also, like -> dd-mm-yyyy, mm/dd, yyyy/mm/dd etc.
Thanks,
Arindam FusionCharts Team
www.fusioncharts.com
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/20/2008 12:09:06 AM
Posts: 37,
Visits: 138
|
|
hi Arindam...thanks for teaching me...
i tried inserting that code into my coding...but i could not get it to work. I don't know where to put it specifically...can you please tell me where to include that query? sorry, i'm still learning..I thank you very much for teaching me! below is my code, please do check and see where in the code should i include the query.
thanks again!
|
|
|
| | |