You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

mapping a date field when some records are blank

Received Response
33
Views
5
Comments
edited Sep 25, 2020 2:52PM in Account Reconciliation 5 comments

Summary

trying to map a posted date field from a bank file, but since some lines don't have posted date, it fails validation (issue date is brought in - that is the required date field)

Content

I have a bank file where I have an issue date (always populated) and a posted date (blank on some lines if check not yet cleared).  I need to bring in both columns, and don't want to set posted as text (lose the ability to filter).  

I've used this script - TO_DATE(UD5,'MM-DD-YY'), and it brings in the dates present, leaving blank the posted date when no value.  But, system doesn't validate, gives an error 'no source ud5'.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!