getting birth dates - Reports

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

1/28/2008 11:03 AM

Manjinder Sandhu

Joined: 5/8/2003

Posts: 14

getting birth dates

how do i write a query which enables me to get birth dates and anniv dates out of the database for the coming week?

1/29/2008 1:35 AM

Casey Caddell

Joined: 1/11/2008

Posts: 7

Re: getting birth dates

I wrote a similar query to find entries that were within the last 2 weeks from a custom defined table:

SELECT [x1], [x2], [xn] FROM [dbxxxxx].[dboxxxxx].[tablename] WHERE ([AnniversaryDateEntryField] >= (GETDATE() - 14))

you can just replace x1-xn with the fields you want returned replace the table name with the users table (users I think) and the Anniversary date field in the table.

Hope that helps.

casey

1/29/2008 3:01 AM

Andrew Nurse

Joined: 4/12/2004

Posts: 433

Re: getting birth dates

That depends on how your database is organized. SQL Server provides functions to get the current date, and you could probably get the current week from that. However, without knowing the structure of the table you want to retrieve data from I don't know for sure.

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

1/29/2008 3:05 AM

Bruno Généré

webiseasy.org
Joined: 10/10/2006

Posts: 20

Re: getting birth dates

You could have a look there :

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70975

Bruno Généré

Page 1 of 1

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)