When we want to use a date as a filter in the Formula Wizard it's currently too complicated as it's expecting a specific format. We would like to be able to use different date format and be sure it...
Change the text that SEI NecAccess function outputs used two digit values for the days and months.
mm/dd/yyyy
instead of
m/d/yyyy
That would allow that fix formula to be
=DATE(MID(C6,3,...