date/time on x-axis
FusionCharts Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        

Home » FusionCharts v3 » Using FusionCharts » General usage » date/time on x-axis

date/time on x-axis Expand / Collapse
Author
Message
Posted 7/31/2008 2:40:10 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum 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.
Post #7744
Posted 7/31/2008 3:30:21 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Moderators
Last Login: Today @ 7:54:06 AM
Posts: 644, Visits: 1,948
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

Post #7745
Posted 7/31/2008 3:50:33 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum 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...
Post #7746
Posted 7/31/2008 6:23:21 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Moderators
Last Login: Today @ 7:54:06 AM
Posts: 644, Visits: 1,948
Please tell me what type of database are you using? SQL Server or MY SQL?

Thanks,
Arindam

FusionCharts Team
www.fusioncharts.com

Post #7750
Posted 7/31/2008 5:15:10 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 11/20/2008 12:09:06 AM
Posts: 37, Visits: 138
i'm using MS ACCESS...
Post #7761
Posted 8/3/2008 6:37:14 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum 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....
Post #7783
Posted 8/4/2008 12:37:18 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Moderators
Last Login: Today @ 7:54:06 AM
Posts: 644, Visits: 1,948
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

Post #7797
Posted 8/4/2008 2:36:14 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum 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!

  Post Attachments 
mycode.txt (5 views, 4.50 KB)
Post #7802