I have a field which has text format in Access, it can have three kind of values
- text "CommonCode"
- text "NotInRSD"
- texts like "2012-02-22"
My target would to convert the third scenario to date format with CDate, in the other two cases it should stay as it is.
I have tried this formula but this does not seem converting the date kind of text to date
DateFormatted: IIf([Date_]="CommonCode" Or [Date_]="NotInRSD";[Date_];CDate([Date_]))