Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sonny1974
  • Order by date
  1. sonny1974

    Flexible Date of Birth Field

    ok onpnt, i will do so. sorry about that, i will make sure i do my own research here before i ask the question. thanks for the heads up before i get kicked off.
  2. sonny1974

    Flexible Date of Birth Field

    I have a DOB field, but i want to make sure that it pulls any kids under 6 what would the formula be if i want to do that. i want to make sure the current date changes daily so it doesnt need to be done manually
  3. sonny1974

    need to get the age

    any ideas how to get rid of the decimal
  4. sonny1974

    need to get the age

    im geeting 66.00 and 2.00 months. how would i take out the 0's
  5. sonny1974

    subracting for age

    oh didnt notice the link , ill check it out
  6. sonny1974

    subracting for age

    sorry im kinda slow today,not sure what the formula should be sorry
  7. sonny1974

    subracting for age

    how would i set up my formula?
  8. sonny1974

    subracting for age

    sql server and crystal xi have a DOB field ex. 5/18/1947. i need to subract the DOB from today (would change daily by it self,not a hard coded today date). just the age would be fine. but if i can get example 60 and 9 months that would be better
  9. sonny1974

    need to get the age

    im using sql server and crystal xi i have a DOB field ex. 5/18/1947. i need to subract the DOB from today (would change daily by it self,not a hard coded today date). just the age would be fine. but if i can get example 60 and 9 months that would be better.
  10. sonny1974

    need took automate date

    sorry sql server is it GetDate()?
  11. sonny1974

    need took automate date

    INDV_PREG"."EXPCT_DUE_DT">={ts '2007-05-04 00:00:00'} i want to change it so i dont have to change it everday. is there a functions like today or something so i can do a a filter on it
  12. sonny1974

    need to look for ages 18-50

    thanks, i really appriciate that everyone gave there expert opinion. this was very helpful
  13. sonny1974

    need to look for ages 18-50

    with all these reply's (thanks for everyone trying to help) im kinda confused. So how should i do this? can i do it without a temp table?
  14. sonny1974

    need to look for ages 18-50

    will i need to adjust the days in the future or will it do automaticly?
  15. sonny1974

    need to look for ages 18-50

    is it possibe to do it by the day? that is what i would need
  16. sonny1974

    need to look for ages 18-50

    i work for the human servies for city of sf, i need to look at only people between 18-50.
  17. sonny1974

    need to look for ages 18-50

    yes that would be better then by the year
  18. sonny1974

    need to look for ages 18-50

    sorry i think the syntx is fine
  19. sonny1974

    need to look for ages 18-50

    is the syntax ok? is it missing a )?
  20. sonny1974

    need to look for ages 18-50

    I have a DOB field i need to filter the dob field to look at 18-50 only how can i put this in my where statement, so when a person runs this report in crystal they dont need to change the DOB to reflect 18-50 but will change the by it self daily so it reflects the right age the field is DOB

Part and Inventory Search

Back
Top