Format

AppSheet AppSheet Q&A
1

How to force system to get month in “04” instead of “4” ?

“INV”
&
RIGHT(YEAR(TODAY()),2)
&
TEXT(MONTH([DATE]),“MM”)
&
“-”
&
RIGHT(“000”&([_RowNumber]-1),4)

TEXT function with two arguments requires a temporal type and text representing a date format

2

Hi @DjLeiii

what about that ?

“INV”
&
TEXT(TODAY(),"yy")
&
TEXT([DATE],"MM")
&
"-"
&
RIGHT(“000”&([_RowNumber]-1),4)
2 Likes
3

HI @Aurelien its works! Thank you :))

1 Like