Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a field with a full format date.
Table1_xls:
LOAD
DATE#(DATE(Fecha,'DD/MM/YYYY')&' '&TIME(Hora,'hh:mm:ss TT'),'DD/MM/YYYY hh:mm:ss TT') AS FechaHora,
...
then I create fields with diferent date format.
Table2_Qvd:
LOAD
FechaHora,
Date(FechaHora,'MM/YYYY') AS MesAño,
Date(FechaHora,'DD/MM') AS DiaMes,
Date(FechaHora,'DD-hh TT') AS HoraDia,
Year(FechaHora) AS Año,
Month(FechaHora) AS Mes,
Day(FechaHora) AS Día,
...
but these fields are kept separate and not grouped by common dates.
what can I do??
Try:
Date(Floor(FechaHora),'MM/YYYY') AS MesAño,
Date(Floor(FechaHora),'DD/MM') AS DiaMes,
Date(Floor(FechaHora),'DD-hh TT') AS HoraDia,
May be this:
Table2_Qvd:
LOAD
FechaHora,
Date(MonthStart(FechaHora),'MM/YYYY') AS MesAño,
Date(MonthStart(FechaHora),'DD/MM') AS DiaMes,
Date(FechaHora,'DD-hh TT') AS HoraDia,
Year(FechaHora) AS Año,
Month(FechaHora) AS Mes,
Day(FechaHora) AS Día,
Hi,
maybe one solution could be:
LOAD *,
Date(MonthName(Fecha),'MM/YYYY') as MesAño,
Date(SetDateYear(Fecha,2000),'DD/MM') as DiaMes,
Date(Date#(Date(FechaHora,'DD-hh'),'DD-hh'),'DD-hh TT') as HoraDia,
Year(FechaHora) as Año,
Month(FechaHora) as Mes,
Day(FechaHora) as Día;
LOAD Fecha,
Hora,
Date(Fecha+Hora,'DD/MM/YYYY hh:mm:ss TT') as FechaHora;
// sample data generation
LOAD Date(MakeDate(2015)+RecNo()-1) as Fecha,
Time(Rand()) as Hora
AutoGenerate 731;
hope this helps
regards
Marco