Hi,
If I retrieve a date (day-month) from my table and show it in the Grid Visualizer it looks different in FF(Firefox) and IE.
In IE the re are no gridlines and the date-cell is breaking up with a new line. FF shows me the gridlines and does't break the cell.
FF
01-02
IE
01-
02
I can live with the lack of the gridlines in IE but how can I suppress the new line in IE?
My query:
select
hl.extranaam + ' '+ hl.naam as Naam, convert(char(5),hl.geboren,105) as Dag
from
my_table hl
where
-- Find next birthday after today
case
when dateadd(yy,datediff(yy,geboren,getDate()),geboren) >
dateadd(dd,datediff(dd,0,getDate()),0)
then dateadd(yy,datediff(yy,geboren,getDate()),geboren)
else dateadd(yy,datediff(yy,geboren,getDate())+1,geboren)
end between
-- Today
dateadd(dd,datediff(dd,0,getDate())+0,0) and
-- Tomorrow plus 6 days
dateadd(dd,datediff(dd,0,getDate())+6,0)
order by datepart(m, geboren), datepart(d, geboren)
Greetz
Rulecourt