Share
Report
90hi Expert,
i have a code that will restart the serial number from 1 from Nov 1 but now my serial number get stuck to 1 and its not going to 2
If(Month(Today()) >= 11 && Day(Today()) >= 1, Dropdown24_1.Selected.Value &"-PIR-"&Year(Today())+1&"-001",Dropdown24_1.Selected.Value &"-PIR-"&Text(DateAdd(Now(),2,Months),"[$-en-US]yyyy")&"-"&Text(Value(TextInput27_5.Text)+1,"[$-en-US]000"))
text input 27_5 is giving value 001
so i need to add 1 to this value.
i can see the
thiss 001 is causing issue but couldn't figure out
regards
Categories:
All responses (
Answers (
