AnsweredAssumed Answered

How do I import dates in a TSV file into FMP10?

Question asked by marksealey on Oct 8, 2009
Latest reply on Oct 10, 2009 by marksealey

Title

How do I import dates in a TSV file into FMP10?

Post

I have an existing FMP 10 file with (two) Date fields.

 

When I try to import a TSV file, in which the corresponding new date fields are in the format 'October 5', 'August 1' etc, they're not imported.

 

(The dates have no year because they represent the yearly start and end dates of publishers' reading periods - and are the same for each year.)

 

I can change these to, for example, '10/05', '08/01' etc. But a year would be meaningless.

 

Anyone any ideas, please?

 

How do I pre-format these fields for import?

 

Or is there a way to hold dates as strings in FMP10, import them as strings and then convert them to date format?

 

TIA! 

 

 

Outcomes