Start a conversation

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). If you want to use this 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.

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Castor Support Team

  2. Posted
  3. Updated