Search by month

[CarlosB]

Hey!

I want to search by month. I have a field that saves the date of when the record was created, so i tried to create a field with a calculation "Month(date)", but that doesn't seem to save the month of the date. I've seen a lot of posts, but I culdn't find one that helped me. Can somebody please help me? Thanks a lot!

[Lee Smith]

Hi Carlos,

Using the Month (date) in a calculation should return a Number result for the month. Be sure that the Date Field is a real Date, and that your calculation has the Result of Number.

HTH

Lee

Edited April 5, 2007 by Guest

[Ender]

If you want the name of the month, use MonthName() instead, with a result of text.

[CarlosB]

This is an example on how my date is being saved: 2007-03-19 15:08:05. I made the calculation field to return Number, but that didn't work. It shows a ?..

[Ender]

That looks like a timestamp, but Month() and MonthName() should still work on timestamps.

[CarlosB]

I'm surely doing something wrong. I have a field called "Date" which saves the date of when the record was created like this 2007-03-19 15:08:05. And I have another field called "Month" which is type Calculation with this calculation: Month (Date), and the calculation result is number. Do you see anything wrong?

[Lee Smith]

Change the field type from Date to Timestamp and see if that doesn't do it for you.

Lee

Edited April 5, 2007 by Guest