/
Date and time formats
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/yyyy | 11/23/2016 |
MM-dd-yyyy | 11-23-2016 |
MM.dd.yyyy | 11.23.2016 |
dd/MM/yyyy | 23/11/2016 |
dd-MM-yyyy | 23-11-2016 |
dd.MM.yyyy | 23.11.2016 |
yyyy/MM/dd | 2016/11/23 |
yyyy-MM-dd | 2016-11-23 |
yyyy.MM.dd | 2016.11.23 |
dd/MM/yy | 23/11/16 |
dd-MM-yy | 23-11-16 |
dd.MM.yy | 23.11.16 |
dd MMM yyyy | 23 Nov 2016 |
d MMM yyyy | 4 Nov 2016 |
dd.MMM.yyyy | 23.Nov.2016 |
Time Formats:
Format | Example | Description |
---|---|---|
HH:mm | 13:30 | H - Hour in a day (0-23) m - Minutes in hour |
hh:mm a | 01:30 PM | h - Hour in am/pm (01-12) a - AM/PM marker |
K:mm a | 1:30 PM | K - Hour in am/pm (0-11) |
k:mm | 13:30 | k - Hour in day (1-24) |
How to add new date format value ?
Navigate to Home → Extras → Dropdown Manager
Click on the Date Format row. This will show you the list of date formats configured in the system.
Click on +Add button.
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.
, multiple selections available,
Related content
Bulk Operations (CSV Import)
Bulk Operations (CSV Import)
Read with this
Advanced Settings (Introduced in v6.1)
Advanced Settings (Introduced in v6.1)
More like this
OpenSpecimen System Settings
OpenSpecimen System Settings
Read with this
Introduction (CSV Import)
Introduction (CSV Import)
More like this
Bulk Import (Video)
Bulk Import (Video)
Read with this
Auto bulk import
Auto bulk import
More like this
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com