Covert YYYY-MM-DD date to Letter for Month, Jan=A, Feb=B, March=C etc Follow
I've found this thread which essentially the same thing I'm trying to do however, more specifically I'm trying to take a date entered from a Date Picker on a Data Entry Form and convert it to the Letter for the month, such as Jan=A, Feb=B, March=C etc and then ideally add YY to the end of it. In other words, for January 2020, the value would be A20.
I know I can create a separate dropdown on the Data Entry form to create the A/B/C values that way, but I would prefer to only have the operator choose one date to reduce risk of a mismatch between Month and the date selected from the Date Picker. The date from the Date Picker is also being dragged into a GS1 UDI so I need the YYYY-MM-DD format to come through for that purpose.
Please sign in to leave a comment.