Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

Date and time formats

You can specify the date and time formats used in input bulk import file. 


Date Formats

Format Example
MM/dd/yyyy11/23/2016
MM-dd-yyyy11-23-2016
MM.dd.yyyy11.23.2016
dd/MM/yyyy23/11/2016
dd-MM-yyyy23-11-2016
dd.MM.yyyy23.11.2016
yyyy/MM/dd2016/11/23
yyyy-MM-dd2016-11-23
yyyy.MM.dd2016.11.23
dd/MM/yy23/11/16
dd-MM-yy23-11-16
dd.MM.yy23.11.16
dd MMM yyyy23 Nov 2016
d MMM yyyy4 Nov 2016
dd.MMM.yyyy23.Nov.2016

Time Formats:

FormatExampleDescription
HH:mm13:30

H - Hour in a day (0-23)

m - Minutes in hour

hh:mm a01:30 PM

h - Hour in am/pm (01-12)

a - AM/PM marker


K:mm a1:30 PMK - Hour in am/pm (0-11)
k:mm13:30k - Hour in day (1-24)

How to add new date format value ?

  1. Navigate to Home → Extras → Dropdown Manager

  2. Click on the Date Format row. This will show you the list of date formats configured in the system.

  3. Click on +Add button.

  4. Specify the Dropdown value as M/dd/yyyy and save it by clicking on the Add button. Refresh the page

5. Navigate back to any bulk import screen, you should be able to see the newly added date format.

Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com