Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CFGridcolumn and Date Formatting
- Thread starter Chloeee
- Start date
- Thread starter
- #3
Nope. The contents of the column. Right now they display as this convoluted mess of numbers. I would like to present the data in the format mm-dd-yy. I can do this in regular cfoutput statements, but within the cfgridcolumn, hmmmm... Any wisdom is appreciated.
- Thread starter
- #5
The following code is from a site administrative interface that displays a grid within a cfform that allows the user to update the scores of games as they are played. In Access, the column GameDate is of datatype "short date". However, in the grid, the GameDate displays in the format 2001-01-23 00:00:00. I need to see this formatted as 01-23-01 instead.
Code:
<cfgrid name="theupdate" query="get_data" selectmode="edit" sort="Yes" sortascendingbutton="Ascending" sortdescendingbutton="Descending" colheaderalign="center" colheaderbold="Yes" height="400" width="610">
<cfgridcolumn name="GameID" display="No">
<cfgridcolumn name="GameDate" header="Game Date">
<cfgridcolumn name="HomeTeam" header="Home Team">
<cfgridcolumn name="HomeTeamScore" header="Score">
<cfgridcolumn name="AwayTeam" header="Away Team">
<cfgridcolumn name="AwayTeamScore" header="Score">
<cfgridcolumn name="Played" header="Played?">
</cfgrid>I am pretty sure you will need SQL to do the trick for you, since only number formatting is enabled in cfgridcolumn.
The following query should work for SQL Server, I am not sure though if it works for Access.
<cfquery name="get_data" datasource="vbdweb2">
SELECT GameId, CONVERT(varchar, GameDate, 10) AS MyGameDate, HomeTeam, HomeTeamScore, AwayTeam, AwayTeamScore, Played
FROM MyTable
</cfquery>
Note that "10" is the constant to convert a date to a standard USA date (as you requested ;-) ), without the century. Also note that you put MyGameDate in the CFGRIDCOLUMN as query column, plus that it is not a date object anymore. Remember this before you try to put the value of this column in a database.
Hope this helps...
<webguru>iqof188</webguru>
The following query should work for SQL Server, I am not sure though if it works for Access.
<cfquery name="get_data" datasource="vbdweb2">
SELECT GameId, CONVERT(varchar, GameDate, 10) AS MyGameDate, HomeTeam, HomeTeamScore, AwayTeam, AwayTeamScore, Played
FROM MyTable
</cfquery>
Note that "10" is the constant to convert a date to a standard USA date (as you requested ;-) ), without the century. Also note that you put MyGameDate in the CFGRIDCOLUMN as query column, plus that it is not a date object anymore. Remember this before you try to put the value of this column in a database.
Hope this helps...
<webguru>iqof188</webguru>
- Thread starter
- #7
Chloeeee, relax man, tell me what version of Access you are using (and I won't ask WHY the ... you use Access 
). Maybe I or someone else (GunJack or iza?) can help you with a substitute for the CONVERT function. Maybe someone in the Access forums has an answer to your question, check it out.
Bottom line is that your date conversion should take place in your query. Good luck!
<webguru>iqof188</webguru>
). Maybe I or someone else (GunJack or iza?) can help you with a substitute for the CONVERT function. Maybe someone in the Access forums has an answer to your question, check it out.Bottom line is that your date conversion should take place in your query. Good luck!
<webguru>iqof188</webguru>
- Status
Similar threads
- Locked
- Question