Hi

I have a CSV data source and have loaded it in using Data Manager. I have a date field and the format is dMMyyyy ie the dates can be 31082010 or 3092010 (data manager see ths original type as integer). I cannot set this as a date field in Field organiser with a format of dMMyyyy as it will not parse the shorter dates so I have created a formula which prepends a zero to the front of the date field so they are all 10 characters long. If I set this formula to be a Date/time I cannot alter the Date format (input) to map the format of my data therefore I have to use string manipulation functions to set it to the format dd-MMM-yyyy. Is there any better way to do this or do I have to do it long-hand using formulas?

Thanks