Convert to Date format/Multiple timestamps

Thanks for data..!!

I tried it with my expression.

Tested in text box.

=(Date(date#(SubField(EXTRACT_TS,' ',2),'DD-MMM'),'DD-MM'))&'-'&Year(today())

When I selected 06-feb..text box is also showing 06-02-2017.

and your data has different time zones.so you need to convert it into one perticular tim zone (or) break your field into 3 pieces for PST,CET,SGT..by using subfield function.

SubField(EXTRACT_TS,'|',1) as PST_zone,

SubField(EXTRACT_TS,'|',2) as CET_zone,

SubField(EXTRACT_TS,'|',3) as SGT_zone

so do you want the output like

dd-mm-yyyy |  dd-mm-yyyy | dd-mm-yyyy   or should one row be split into three rows??

try like

LOAD EXTRACT_TS,

  DATE(Date#(mid(trim(subfield(EXTRACT_TS,'|',1)),5,6),'DD-MMM'),'DD-MM')&'-'&Year(today()) as Extract_DATE,

     Business_Group,

     Business_Sub_Group, ..........your usual load

Check the attached, works for me!

LOAD EXTRACT_TS,

DATE(Date#(mid(trim(subfield(EXTRACT_TS,'|',1)),5,6),'DD-MMM'),'DD-MM')&'-'&Year(today()) as Extract_DATE,

     Business_Group,

     Business_Sub_Group,

     GBU,

     PL,

     Platform,

     Model,

     Product,

     Material,

     Material_Description,

     Plant,

     Sales_document,

     SO_Item,

     Order_quantity_EA,

     Partial_qty_EA

FROM

[C:\Users\vp51284\Downloads\TESTING_Backlog_MQ_consolidated_Latest_Run_20170207.xlsx]

(ooxml, embedded labels, table is Backlog_MQ_consolidated_Latest_)

Where len(trim(EXTRACT_TS))>0;