Date Problem

[pgalvezt]

Hello,

I have two information sources (xls and csv).

I need to concatenate both tables. (xls come in format DD-MM-YYYY. csv in DD/MM/YYYY

I tried this but doesn't work:

Date(Date#(Left(FECHAYHORA, 10), 'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY') as Id_date

FECHAYHORA is in csv...

Thanks!

[sunny_talwar]

Why don't you use [FECHA Y HORA] to create intervals? and use Id_date as just date?

[pgalvezt]

Right...

I was using for all my calculations (Intervals) Id_date...

I can see now hour minute etc,

Thanks!