Date Field

[Adhie]

Is there any possibility to input Month & Year only into Date Field without knowing the day?

e.g; when I enter 05/04 will be displayed as May, 2004

FileMaker Version: 6

Platform: Windows XP

[Reed]

I don't think it's possible because of the way dates are represented (as the number of days since some past date) You could specify a range of dates to denote an entire month.

[Mike D.]

Try this - Create two number fields MonthField and YearField. Next create a calculation field MonthYear = Date( MonthField, 1, YearField) and have it return the results as a date. Format the MonthYear field to only show the month and year.

Mike

[Adhie]

Hi Mike,

Thanks for help. It's very educational. Anyway, I'm not so sure but is it possible to have only 1 field for it? Just MonthYear field, as I entered 05/04 to MonthYear Field then automatically will be displayed as May, 2004.

Thanks.

FileMaker Version: 6

Platform: Windows XP