Convert String to Date?

Last Post

RSS

Posts: 21

Rob Cushen

September 13, 2020 7:53 am

(@robcushen)

21-50 Posts

Joined: 6 months ago

Hi,

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?

Thanks!

Forum Statistics

11 Forums

1,531 Topics

7,083 Posts

6 Online

932 Members

Latest Post: Using Templates as "canned responses" Our newest member: thanhthuy02 Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Convert String to Date?

Online Members