How can i make a Date filter

db , sql United States
  • 13 years ago

    I am working with Microsoft CRM 3.0 and I have to make a report with the accounts name, telephone, campaign response, date and with an questionary(questionnaire) and I have to make filters with camapign response code and date. The camapign response filter I've made it but I don't know how to make the date filter.

    The tables I've used are from CRM DATABASE : AccountBase, Activity Party, Camapign Response from Tables and from Views in Campaign respose table CreatedON.

     I would like to make this filter like a picklist with today, yesterday, last week and this monthly.(if it can be make)

    If not at least to modify it every day and put the date in the code every morning or every evening.

    Thank You,

    Hope to help me!

     

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“We better hurry up and start coding, there are going to be a lot of bugs to fix.”