Looks like you need to store Effective to something before performing that assign. If you are wanting to store it after the assign then you would need to use an If condition to get around the error.
For example:
Assign Effective = If(Effective=Nothing,Nothing,DateTime.ParseExact(Effective, “MM/dd/yyyy 00:00:00”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”))
1 Like