Data Format conversion

[bhavvibudagam]

Hi Everyone,

Can any one please help me on conversion of below formated Month field to Date Field.

It contains Month - Year and Number format values.

Thanks in Advance

[Anil_Babu_Samineni · Accepted solution]

May be this?

Alt(Date(Date#(Month, 'MMM-YYYY'),'MMM-YYYY'), Date(Num(Month),'MMM-YYYY'))

[Peter_Cammaert]

To turn those numbers into dates, use a Date() formatting function in your Load statement.

The first half of your list box contains values that are exclusively present as strings, not as Dates. The difference between the two sets points to a script loading from different sources. Use proper parsing ( e.g. Date#() ) and formatting functions (e.g. Date() ) to turn both date sources into properly formatted values.

[bhavvibudagam]

Thank you Anil