AnsweredAssumed Answered

changing a number field to a date field

Question asked by david.page@dwpage.com on Nov 6, 2016
Latest reply on Nov 7, 2016 by david.page@dwpage.com

When I download my banking information in a CVS format and then convert to xlsx the date seems to only download as a number field eg:

(20161105) is there a way I can take this number field and convert it (or set up a new calculation field) so it would read as a date - 11/05/2016  ?

Thank you for any help.

David

Outcomes