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!

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, 200718 yr by Guest

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

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 ?..

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

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?

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

Lee

Edited April 5, 200718 yr by Guest