Problem with the use of dates.
I'm going to go crazy with ARAS. After several hours using dates, and it didn't work out, I discovered date is stored in the databse in "neutral" date, here in Spain it is +1. That's why the "GET" did not work for me, etc.
Well today, continuing with the work I have realized that depending on whether or not I use "where" I must put the neutral date or with my time zone.
Can you confirm it? It is right?.
// In this, i must to GET the date - 1 hour (Spain is +1). Neutral Date CodigoAML = "<Item type='MP Control Descanso' action='get' where=\"[MP_Control_Descanso].mp_fecha_entrada='" + extraeDia(HoraA,1) +"' and [MP_Control_Descanso].mp_con_usr = '"+localizaTrabajador(TrabajadorDNI)+"' and [MP_Control_Descanso].mp_estado = '1'\"></Item>"; // In this, i must to GET the date in my GMT CodigoAML = "<Item type='MP Control Descanso' action='get'><mp_fecha_entrada>" + extraeDia(HoraA,0) +"</mp_fecha_entrada><mp_con_usr>"+localizaTrabajador(TrabajadorDNI)+"</mp_con_usr><mp_estado>0</mp_estado></Item>"; var ResultadoGet = innovator.applyAML("<AML>"+CodigoAML+"</AML>");