Dateformat - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Dateformat

Author

Topic

RishiPatel
Starting Member

2 Posts

Posted - 2005-11-29 : 17:32:01

Hiya all,

i am making a chart in coldfusion MX7, with an access query, here is my query:


SELECT DISTINCTROW MemberDoesActivity.Date, Sum(MemberDoesActivity.Cal) AS [Sum Of Cal],
FROM MemberDoesActivity
GROUP BY MemberDoesActivity.Date;

The problem is the webpage i am using is displaying the full date/time, where as i only want the date.

has anyone got any ideas?

thanks
Rishi Patel

shallu1_gupta
Constraint Violating Yak Guru

394 Posts

Posted - 2005-11-30 : 00:47:35

Use Date format function at your web page to format date the way u want.

RishiPatel
Starting Member

2 Posts

Posted - 2005-12-04 : 14:41:31

It has to be done in the SQL, as DateFormat cannot be used in the coldfusion, which is what i thought first, i tried the below, and it returns an error.

<cfchartseries type="bar"
query="qGetMembersCalsBurnt"
valuecolumn="SumofCal"
<itemcolumn="DateFormat(Date, dd/mm)">

does anyone know how i can modify my SQL to format the date?

thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-05 : 00:59:51

Cant you get only date and month values and combine them?

Madhivanan

Failing to plan is Planning to fail

sdarDavid
Starting Member

1 Post

Posted - 2006-01-11 : 21:37:23

Did anyone ever find the answer to this question. I have the same problem using Cold Fusion to generate charts with formating a date.

David
david@sdar.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources