CFGRID Formatting

[PDL]

Old age perhaps but I thought I remembered seeing a means of formatting a date field in a CFGRID?? Can't seem to make it work! Real tired of seeing ODBC date formats! Any pointers appreciated!

 

[RedLion]

Hi PDL

What have you got, and what of it is not working? So we see what your doing wrong, and we can help you.


Charl

 

[DarkMan]

If you're using SQL Server, you could try something like:

SELECT CONVERT(char, MyDateField, 107) as TheDate 
FROM MyTable

(returns dates like Oct 10, 2000 and Jan 02, 2000)

or

SELECT CONVERT(char, MyDateField, 101) as TheDate 
FROM MyTable

(returns dates like 10/10/2000 and 01/02/2000)

in your query.
Hope this helps... DarkMan

 

[cturland]

You can use CF to format your date,

Example code:

DateFormat (#YourDate#, "d mmmm yyyy&quot

 

[cturland]

uhhhh, actually that wont work! - I must have been tired when I typed that!!

Try:

DateFormat (#YourDate#, "d mm yyyy&quot

 

[DarkMan]

I think it's

#DateFormat(YourDate,"d mm yyyy&quot#, but I don't think that'll work in a query driven CFGRID.... DarkMan

 

[PDL]

Got DarkMan's to work nicely.

Using <CFGRIDCOLUMN Name=&quot;Cost&quot; Header=&quot;Cost&quot;>

Where wold one put the DateFormat (#YourDate#, &quot;d mm yyyy&quot??

<CFGRIDCOLUMN Name='DateFormat (#cost#, &quot;d mm yyyy&quot??' Header=&quot;Cost&quot;>