Regarding Date Conversion

[ashiques]

Hi All,

I have a field which i transpose and get this value in  Row = "04/04/09". Now i have to update the new  file in previous file which have different field name which after transpose look like this "1m End APR-09".
So how can i convert "04/04/09" into "1m End APR-09". I didnt get any expression or function in Datetime tool.


Thanks in Advance

[ChadM · Accepted solution]

Hi Ashique,

The value "1m End APR-09" is not a standard date format, so you will most likely have to create a custom lookup to convert "04/04/09" to "1m End APR-09".  Once you create the lookup table, you can use that with the Dynamic Rename Tool to update your field names to the desired output.