Remove Time from DateTime field 1

[palock]

I need to print just the Date of Birth from a DateTime field and eventually calculate the Age. I tried the formula from a Trim Number post, but it is not working - says that I need a string or array.

Any suggestions?
Thanks!

 

[Durango122]

Hi
check this link to ken

http://www.kenhamady.com/formula.html

lots of formula



Durango122

 

[palock]

Thank you Durango - that site is wonderful. Unfortunately it does not have a way to strip the time off of the Date of Birth - it seems as if this should be fairly simple, but I am having a tough time...I am new to CR and may not quite have the hang of it yet.
Palock

 

[lbass]

Just change Ken's formula by wrapping the datetime with date():

WhileReadingRecords;
DateVar Birth:= date({ages.Birth}); // Replace this with your field for Date Of Birth
DateVar Ann := {ages.DateAnn}; // Replace this with CurrentDate to get their age as of the time of the report
//or the date field of an event to get their age as of the time of that event.
if (Month(Ann) * 100) + Day (Ann) >=(Month(Birth) *100) + Day (Birth)
then Year (Ann) - Year(Birth)
else Year (Ann) - Year(Birth) -1

-LB

 

[damonkimble]

If you are trying to print a single field, just right click Format Field. You can choose from a variety of date and/or time combinations.

As far as age goes, it is surprising that there still isn't a good built-in function. Here is a custom function I made.

Function  (DateTimeVar dstart, DateTimeVar dend)
// Returns number of year between two input dates
// Apparently there is no issue with DateAdd when subtracting years off of leap day
//  , so no need to isDate...

if DateAdd ('yyyy', -(DateDiff ('yyyy',dstart ,dend )), dend) >= dstart
    then DateDiff ('yyyy',dstart ,dend )
    else DateDiff ('yyyy',dstart ,dend )-1

or you put in a function and replace dstart and dend with your desired variables.

hth,
damon

 

[palock]

Thank you all for your help - forest for the trees syndrome! I am off and running now and will play with both age calcs...
Palock