7 Replies Latest reply on Aug 8, 2013 8:01 AM by philmodjunk

    Searchable date field by month/year

    PeterPitt

      Title

      Searchable date field by month/year

      Post

           Hello

           I'm a bit stumped by this so hope someone can help.  I have a date field called Chase Month that looks up an existing date field and automatically adds on 60 days (2 months) in order for users to see when they may need to send a follow up letter.  To do this I've used:

           MonthName (GetAsText (date+60))

           This calculation works fine but I'd like to display the result with both the month and the year, although NOT the day.  Eg. 01/08/2013 should display in the field as August 2013. I'm only seeing the month using the above expression.  The current setting is to display the calculation result as Text.

           Additionally I would like the Chase Month field to be searchable as Text so that users can search for results by particular months/years rather than specific dd/mm/yyyy results.  Eg.Create a Find in the field for 'August 2013' to display all records for that month irrelevant of day.

           Any suggesitons on how to tackle this?

           Many thanks