I am really stumped on this one. I built this if statement to create a load sheet from another sheet but the dates are entering as a number instead of a date.OES!M4 is a date 03/06/2020 but when it concatenated on the load sheet it looks like this 43896. In the examples below the top is what I'm getting the bottom is what I want.HTML Code:
0248 - OES CORRECTIVE ACTIONS - 43996 - 510003853
0248 - OES CORRECTIVE ACTIONS - 03/06/2020 - 510003853
Bookmarks