Convert String to Date?
Have the following situation...
Lot numbers are currently entered in the format YYYYMMDD
I am trying to convert this value to a Date (i.e., 20200101 would represent Jan 1, 2020).
The following formula yields a very date-like looking string with all rows being returned.
=Concat(CStr(CInt(Substring( [INLotSerialStatus.LotSerialNbr], 5, 2))), '/',CStr(CInt(substring([INLotSerialStatus.LotSerialNbr], 7, 2))),'/',substring([INLotSerialStatus.LotSerialNbr], 1, 4) )
I tried to wrap the formula above in a CDate() function (which passes as a valid formula), but yields a "No records found as 'All records'" message.
Any thoughts on how to format the value as a "Date" and return data?