getting expected 4-digit year in date/period

Options

Please find the below ss.

Answers

  • Select correct format of period which is DD/MM/YYYY in Import Window. You can also choose Custom names

    Regards,

  • @vyshnavsk,

    Go to the Time tab and try any of the two formats mentioned below.

    Pattern with Separator

    Custom fixed-position pattern