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
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.
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.