Date fields importing as Text
Hi! I recently imported a user file with a field in it called Termination Date. I didn't have anyone terming soon, so all the entries were blank. When I tried to set up a distribution list for an exit survey I'm developing, it was unavailable as an option. I uploaded a new file with a couple of dates in it, hoping it would pick it up as a date field, but when I went to use the attribute in my distribution list, it looks like it is assuming they are text rather than dates. My other date fields worked (hire, birth) and it is set up in the same format (not getting any errors on upload. My next step was to make a new field (term date) with 6 dates in it, hoping I could use that. I went through the New User Schema or Attributes update, but it still picked my new field up as text. How can I force it to knowing that my field is a date? Is it because I don't have a date in the very first record? Is there somewhere I can change the field setting from Text to Date? Is something else going on that I'm not thinking of and this isn't my problem at all? Any guidance appreciated.