Check if entered date is in US format (mm/dd/yyyy)
In the United States, the date format begins with the month and ends with the year (mm/dd/yyyy).
Study admins can define a custom date format for each institute in the Settings tab.
If you want to use an alternative format, we recommend you to use a text field. In this text field, you can use the formats:
- mm/dd/yyyy
- mm-dd-yyyy
- mm.dd.yyyy
To check the date, use the following template in a calculation field, which displays the entered date in text format. That means that if you enter 01/30/2025 in the text field, the calculation will show "30 January 2025". Replace the variable your_text_field with the variable name of your own text field.
var date = '{your_text_field}';
if(/^((0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01])[- /.](19|20)?[0-9]{2})*$/.test(date)) {
var current_datetime = new Date(date);
var months = ["January", "February", "March","April", "May", "June", "July", "August", "September", "October", "November", "December"];
var formatted_date = current_datetime.getDate() + " " + months[current_datetime.getMonth()] + " " + current_datetime.getFullYear();
formatted_date;
} else {
"Please enter the date in the right format (mm-dd-yyyy)"
}
Text the calculation in the calculation helper.