If I have date and time in the same column how can I separate them in two columns in ArcMap? And how can I put the date in this format (year,month,day)?

enter image description here

  • Welcome to Geographic Information Systems! Welcome to GIS SE! We're a little different from other sites; this isn't a discussion forum but a Q&A site. Your questions should as much as possible describe not just what you want to do, but precisely what you have tried and where you are stuck trying that. Please check out our short tour for more about how the site works
    – Ian Turton
    Mar 3, 2021 at 13:14

1 Answer 1


Use DatePart("PART", [DATEFIELD]) in the Field Calculator.

The PART argument can be one of the following keywords: yyyy (YEAR), m (MONTH), d (DAY), h (HOUR), n (MINUTE), or s (SECOND)

See here: https://support.esri.com/en/technical-article/000014933

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.