Jump to content

Find a specific month


Bruno Dini
 Share

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

Recommended Posts

Bruno,

The simplest way is to do use the range expression;

2/1/2006...2/28/2006.

Or you could add a new field:

calculation, number result = Month(date);

or if you prefer the text equivilent:

calculation, text result = MonthName(date).

Put this field on your layout and search by 2, or by February.

*susan*

Link to comment
Share on other sites

You can also use wild cards in your search (since version 8). Check FM Help for some cool examples. Be careful searching for just the month because you'll get all years. So to search a date field, you can type:

2/*/2007

I love the new wildcards feature but I forget to use it as often as I should. :smile2:

Edited by Guest
Link to comment
Share on other sites

This topic is 5705 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
 Share

×
×
  • Create New...

Important Information

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