Format

[DjLeiii]

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

[Aurelien · Accepted solution]

Hi @DjLeiii 

what about that ?

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

[DjLeiii]

HI @Aurelien its works! Thank you :))