"Neal Piche" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > ok so here is what I've got, I have to fields move in and move out both in > date format and a third field length which I would like to show # yrs # mo > # days automatically. when I tried to make the third field a date to show > the difference it gives me a nonsense date I realize now that is because > it is taking the integer value that is returned when subtracting dates and > using it as it's internal representation. so I guess I have to use a > number field but I just don't know what to do please help
I think I understand you to be saying you want the different between two dates to be expressed in the form of number of years, months and days. Have a look at the DAYS, MONTHS, YEARS functions. You'll probably have to use a formula to format a string in the format you want. I don't know how you'll handle the leap year issue. -- Bob Long P.S. You have written to a mailing list where help is provided by volunteers. Please reply only to the mailing list at [EMAIL PROTECTED] FAQ, userguide, etc: http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]