How do I create a date from JAN2013

[#1]

My date file that  am importing has the Date as JAN2013 how do I make a date from that?

[Chanty4u]

like below,

aa:

LOAD * INLINE [

    Date

    Jan12

    feb2012

];

Ressult:

LOAD *

,

Date(Date#(Date,'MMMYY'),'DDMMYYYY') AS NEW

Resident aa;

[miguelbraga]

Is this what you're looking for?

See the attached file

Regards,

MB

[miguelbraga · Accepted solution]

Even try this as multiple date formats because you refered first as JAN2013, then Jan12 or Jan-12:

Alt(

     Date((Date#(Date, 'MMM-YY')), 'DD/MM/YYYY'),            // for case Date comes with Jan-12

     Date((Date#(Date, 'MMMYY')), 'DD/MM/YYYY'),             // for case Date comes with Jan12

     Date((Date#(Date, 'MMMYYYY')), 'DD/MM/YYYY'),         // for case Date comes with JAN2013

      'Invalid Format'                                                            // If date comes with an invalid format

) as Date

Regards,

MB