Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7519 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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

Posted

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.

Posted

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

  • Newbies
Posted

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

This topic is 7519 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.