date/time on x-axis

[bender]

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.

[Arindam]

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.

Edited July 31, 2008 by Guest

[bender]

thanks for the reply...

 

 

 

but how do you format the date? can you give some example code? sorry, i'm a total newbie...

[Arindam]

Please tell me what type of database are you using? SQL Server or MY SQL?

[bender]

i'm using MS ACCESS...

[bender]

hello??? anybody got any ideas??? help me please....:crying:

[Arindam]

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.

[bender]

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!

mycode.txt

[Arindam]

hi,

Could you please try this code.

test.php.txt

[bender]

hi Arindam,

 

 

 

it worked! thank you very much! have a nice day