getting expected 4-digit year in date/period

Please find the below ss.


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


  • @vyshnavsk,

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

    Pattern with Separator

    Custom fixed-position pattern