Sage 100

End user has a VI job where they are trying to import a date from an import source where the date is formatted as M/D/Y m:h:y Anyone have to create formula within VI to strip out the time at the end of this field?

Is the date such that Source Substring can be used?

I don't think so because it's not sending mm/dd/yyyy -- instead I only get m or mm depending upon whether there's one or two digits in the month.

How about DTE(date$[:fmt$][,ERR=stmtref]) If you don't specify a format, it defaults to MM/DD/YY.

Good idea - I forwarded it along - thanks!