Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
LivingstoneTechie #1
Birthdate Calculations
How do I use SQL to get all records from an Access Database where the birthdate
of an individual is within that week? I was trying a > Now()-1 and < Now()+7,
but that only checks to see if they were born yesterday ;) and yet to be born?
How do I narrow the search to only Month and Day?
Thanks,
Dustin
LivingstoneTechie Guest
-
Calculations not working
Hi All, getting frustrated. I've done forms with calculations (invoice sheets etc.) and they worked well in the past. I can't seem to get the... -
How to convert from BirthDate to Age
Hi ! please help - I have tabel with a Birthday column in a access database and need to show the age in a datagrid.... -
Calculations with date
Hello all, I am looking for an advice or suggestion in this task: I do have a Perl script which contains 2 variables ($low, $high). The value... -
date calculations
Nadya, In days? =DateDiff("d",,) or simply = - -- Fred Please reply only to this newsgroup. -
column calculations
create a computed column to add year to the existing column See following example. CREATE TABLE dbo.t2 ( dt datetime NULL, next_yr AS... -
OldCFer #2 Re: Birthdate Calculations
Use:
Select Name, birthdate from employees where month(birthdate) = 4
and Day(birthdate) >= 21 and Day(birthdate) <= 28
It will return everyone born between April 21 and April 28
OldCFer Guest
-
LivingstoneTechie #3 Re: Birthdate Calculations
Thanks Larry!!!
Everything is working great!
Dustin
LivingstoneTechie Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
