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

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.

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

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