Re: Search records occurring on Saturday by George
George
Thu Jun 14 00:17:57 CDT 2007
Hi msandid,
interesting, interesting. One obvious option is to create a custom report.
The advantage is that users will be able to specify day of the week they're
after at runtime.
If you want to use Advanced Find to create custom view then you need to go
an extra mile because Advanced Find does not allow any calculations. What I
had in mind is:
1. Add integer column, say new_dow
2. Create PreCreate/PreUpdate callouts that insert value into new_dow
whenever your date field is updated. The value as you've already guessed is
a day of the week.
3. Create throw-away code to "touch" your existing records so that callout
gets invoked and dow is updated. Alternatively, resort to usupported direct
SQL (just make sure you backup your database first!).
4. Use Advanced Find to build the view and use new_dow column to filter
required day of the week.
Hope it helps
--
George Doubinski
CRM Certified Professional - Developer
"msandid" <msandid@gmail.com> wrote in message
news:1181767280.972234.107340@i38g2000prf.googlegroups.com...
> Hi,
>
> I have a request to return all records this year with a date falling
> on a Saturday. Does anyone know how to do that using Advanced Find, or
> otherwise? How to select all dates in a period of time that fall on a
> particular day of the week!
>
> Thanks,
> Mo
>