Problem with a date in a grid

Applications Grid / Reports
#1

Hi all, I made a grid with this sql statement:

SELECT
  Beneficiarios.Codigo,
  Beneficiarios.Nombre,
  mov_Ingreso.Nro_Internacion,
  mov_Ingreso.Cod_Beneficiario,
  mov_Ingreso.Cod_Tipo_Ingreso,
  mov_Ingreso.Fecha_Ingreso,
  movimientos.Nro_Internacion,
  movimientos.Fecha,
  movimientos.Tipo_Movimiento,
  movimientos.Cod_Institucion,
  movimientos.Estado,
  movimientos.Cod_Tipo_Pase,
  movimientos.Cod_Sede,
  movimientos.Tiempo_Prorroga
FROM
  dbo.Movimientos_Beneficiarios mov_Ingreso INNER JOIN dbo.Benefi Beneficiarios ON mov_Ingreso.Cod_Beneficiario = Beneficiarios.Codigo
  INNER JOIN dbo.Movimientos_Beneficiarios_1 movimientos ON mov_Ingreso.Nro_Internacion = movimientos.Nro_Internacion
WHERE mov_Ingreso.Cod_Beneficiario = '[Codigo]'

All works fine, but the date shows like a text “1994-10-13T00:00:00Z”. No matter if I change the type of field to date, date and time or text allways show the same.
Of course the field in database is the type datetime, so, that’s no the problem.

I try to made a grid just with the table, not with the sql statement and in this case the date shows correctly.

Any ideas??

Thanks in advance,

Marcelo

#2

Re: Problem with a date in a grid

Did you enable the Regional Settings ? and try to disable, to format the data like you want ?

regards

#3

Re: Problem with a date in a grid

Yes I Enable and disable the regional settings, and i Try to format the data in diffeent ways, but allways shows the same.

(I try to made a new grid with the same sql statement and the same was happens, so is not a problem for this particular app)

#4

Re: Problem with a date in a grid

which database do you use ?

#5

Re: Problem with a date in a grid

Hi, sorry for delay, I was not notified by mail.

I use SQL SERVER.

BTW, today try with another grid, with another sql statement and the same was happend.

The field shows SQL TYPE 93, instead of DATETIME or SMALLDATETIME or where ever.

Maybe a bug since last uopdate??

#6

Re: Problem with a date in a grid

Hello sir,

I teste here with SQL Server 2005, without problem, with field types date,datetime…
You can request help in email bugs@netmake.com.br, send the app and the table you found this error.
If it’s really a bug they will enter in contact with you.

regards

#7

Re: Problem with a date in a grid

Ok, I will do that, but you recomend try to reinstall the system??

Maybe something was broke…

#8

Re: Problem with a date in a grid

instead of re-install, you can update manually the Scriptcase
see the link: http://www.scriptcase.net/phpgenerator/baseknowledge/baseknowledge.php?id_topico=270