Need a script to search a date field and find the records which are within a month of the current date
Enter find mode
Set field [ dateField ; getasdate ( get ( currenthosttimestamp ) ) - 30 & "..." & getasdate ( get ( currenthosttimestamp ) ) + 30 ]
I think this is something I am looking for too as I am trying to find a way to create a search of a calendar field.
Particularly to show all the people who have birthdays in a month as per my "Birthday" field.
Would you mind in describing a little clearer how to go about this?
Hi! there are several discussions on Birthdays. You might search this forum for 'birthday' or 'birthdate'.
Retrieving data ...