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?
@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.
@Levent_KULACOGLU Hi! Tried your suggestion. Ended up with this error message
Pls advice.
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()))
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |