FormatDateTime with CDate wrapper not returning Date data type in make table query
I have this line of code in my Access Make-Table query and it returns the right value, however, when i open the table it creates and look at the properties, all my date fields are formatted as Text. Anyone know why this might be?
LA: IIf(Item001_AllFilesPresent![Last Accessed] Is Not Null,(CDate(FormatDateTime(Item001_AllFilesPresent![Last Accessed],1))),"")
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)