dkmiller16
New Member
- Joined
- Oct 31, 2013
- Messages
- 13
I am trying to create a form that will generate a PO#, I would like to have the first 4 numbers be the current year/month "yy/mm" followed by a 2 digit incrementing number starting with 01. For example if I create 4 PO#'s in April 2021 and then 3 in May of 2021 I would have the following.
210401
210402
210403
210404
210501
210502
210503
This will allow me to look at the PO# and determine what month/year it was created. For this purpose I will never exceed 99 PO#'s in a single month.
Thanks
210401
210402
210403
210404
210501
210502
210503
This will allow me to look at the PO# and determine what month/year it was created. For this purpose I will never exceed 99 PO#'s in a single month.
Thanks