Hi,

I want to allow input of birthdates in a script. Because using the calendar in the date input script component requires too many clicks, I want to use the input script component and validate it so that an input of DDMMYYYY is automatically formatted with dots as DD.MM.YYYY. I tried it with the following regex:

def format_date(input_date):

    formatted_date = re.sub(r'^(\d{2})(\d{2})(\d{4})$', r'\1.\2.\3', input_date)

    return formatted_date

However, when I test it in preview mode, the input field is highlighted in red, and the format is not converted. Can someone tell me how I need to formulate the regex?

Viele Grüße,

Thomas

Variable formatted_date should be configured as a String - dynamic. 

Dynamic Value: 

substr({{input_date}},0,2) + "." + substr({{input_date}},2,2) + "." + substr({{input_date}},4)

In Preview, it looks like this: 

Hi,

I want to allow input of birthdates in a script. Because using the calendar in the date input script component requires too many clicks, I want to use the input script component and validate it so that an input of DDMMYYYY is automatically formatted with dots as DD.MM.YYYY. I tried it with the following regex:

def format_date(input_date):

    formatted_date = re.sub(r'^(\d{2})(\d{2})(\d{4})$', r'\1.\2.\3', input_date)

    return formatted_date

However, when I test it in preview mode, the input field is highlighted in red, and the format is not converted. Can someone tell me how I need to formulate the regex?

Viele Grüße,

Thomas

Thank you very much for your response, Tatjana.

Unfortunately, I am not able to see it in the preview mode as it is shown in your screenshot. Apparently, I have configured the input component incorrectly and I can't figure out how to do it. May I ask you to also provide me with a screenshot of your input configuration?

Viele Grüße,

Thomas

Variable formatted_date should be configured as a String - dynamic. 

Dynamic Value: 

substr({{input_date}},0,2) + "." + substr({{input_date}},2,2) + "." + substr({{input_date}},4)

In Preview, it looks like this: 

Hi,

I want to allow input of birthdates in a script. Because using the calendar in the date input script component requires too many clicks, I want to use the input script component and validate it so that an input of DDMMYYYY is automatically formatted with dots as DD.MM.YYYY. I tried it with the following regex:

def format_date(input_date):

    formatted_date = re.sub(r'^(\d{2})(\d{2})(\d{4})$', r'\1.\2.\3', input_date)

    return formatted_date

However, when I test it in preview mode, the input field is highlighted in red, and the format is not converted. Can someone tell me how I need to formulate the regex?

Viele Grüße,

Thomas