Gareth Horton
July 12th, 2002, 02:24 PM
Your dates are not properly formatted as m/d/y, so Monarch handles it as text.
there is no way to read it as a date field without all the parts.
My suggestion is to capture each part of the text, then use a calculated field formatted as date and add the
1st day of each month.
Heather Delaney wrote:
> On a text file I have data that appears like this;
>
> 01/1999
> 02/2002
> 12/2001
>
> It will only pull into the table as a character/text not a date. When I set it to a date it nulls out in the table. Does anyone no how to fix this??
>
> Thanks ,
> Heather
there is no way to read it as a date field without all the parts.
My suggestion is to capture each part of the text, then use a calculated field formatted as date and add the
1st day of each month.
Heather Delaney wrote:
> On a text file I have data that appears like this;
>
> 01/1999
> 02/2002
> 12/2001
>
> It will only pull into the table as a character/text not a date. When I set it to a date it nulls out in the table. Does anyone no how to fix this??
>
> Thanks ,
> Heather