Recent content by sonny1974

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.

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

any ideas how to get rid of the decimal

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

oh didnt notice the link , ill check it out

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

how would i set up my formula?

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

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.

sorry sql server is it GetDate()?

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

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

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?

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

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