nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using formula editor to reformat lot numbers to date format in a separate column.

joshcummins

Is there a way to use the formula editor to reformat a lot number to date format in a separate column? The lot numbers are formatted as such: MMYYDD.B where "B" is the # of the batch for day. I would like to be able to create a formula that takes the lot number and converts it to the following date format: MM/DD/YY or MM/DD/YYYY.

Accepted answers

txnelson

create the new column. Enter in the following format:

Date MDY(Num(Substr(lotid, 1, 2)), Num(Substr(lotid, 5, 2)), Num(Substr(lotid, 3, 2)))

Finally, go to the Column Info for the new column and specify to use the date format

m/d/y

All comments

txnelson

create the new column. Enter in the following format:

Date MDY(Num(Substr(lotid, 1, 2)), Num(Substr(lotid, 5, 2)), Num(Substr(lotid, 3, 2)))

Finally, go to the Column Info for the new column and specify to use the date format

m/d/y

joshcummins

Thanks for this. It worked as intended. Also, thanks for the fast turnaround time.

Josh Cummins

Analytical Chemist

Dynaloy LLC A subsidiary of Eastman Chemical Company

W: +1.423.229.8771

M: +1.317.223.3487

Jeff_Perkinson

The Word() and Informat() functions make this pretty easy.

https://www.youtube.com/watch?v=9nRaDwsYB28

-Jeff