Hello, how do I format the dates? In Sweden w...

(Peter Westin) #1

Hello, how do I format the dates? In Sweden we format dates like yyyy-mm-dd: month and date with 2 digits, but AS showns only 1 digit,

How do I change that?

(Levent KULAÇOĞLU) #2

@Peter_Westin you can use below expression in your Initial Value for the date column:

=CONCATENATE(YEAR(TODAY(),"-",IFS(MONTH(TODAY())<10,“0”),MONTH(TODAY()),"-",IFS(DAY(TODAY())<10,“0”),DAY(TODAY())

Also check if your sheet reflects the same format.

(Peter Westin) #3

@Levent_KULACOGLU Hi! Tried your suggestion. Ended up with this error message

Pls advice.

(Levent KULAÇOĞLU) #4

@Peter_Westin

it seams I might have forgot some paranthesises. Sorry. Here it is:

=CONCATENATE(YEAR(TODAY()),"-",IFS(MONTH(TODAY())<10,“0”),MONTH(TODAY()),"-",IFS(DAY(TODAY())<10,“0”),DAY(TODAY()))