[WD21] FileToMemory & FileToArray with dates

Startbeitrag von Mr Black am 20.12.2016 17:22

In data file, I have blank dates stored as "00000000". When running a query against the file the query returns blank dates as "00000000" as expected.

If FileToMemory or FileToArray is used to transfer into either a structured variable or structured array, the blank dates are transformed from "00000000" to today's date. Same applies if dates are stored as blanks ie. ""

I'm not really looking forward to coding all the mappings manually. Anyone else seen this?

Dave

Antworten:

Re: [WD21] FileToMemory & FileToArray with dates

Ok dumb is as dumb doo.. Had a spelling mistake in structure so structure date variable was defaulting to DateTimeByDefault, which by default is current date. All working now..

thanks.

Dave

von Mr Black - am 20.12.2016 17:53
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.