Page 1 of 1

Converting day into a current date

Posted: Fri Dec 28, 2001 2:42 pm
by consume2
I am using a field that has a day of the month values only, such as the 19th, 21st or 24th, I want to convert that value to where it displays that day with the current month and year such as 12/19/01, 12/21/01 or 12/24/01.____Any ideas?

=> Converting day into a current date

Posted: Sun Dec 30, 2001 11:35 am
by kfleming
You could use the expression:____str(day(date()),2) "/" str(val(fieldname),2) "/" str(month(date()),4)____where fieldname is the field containing the string "19th","21st"...______Kathleen__R&R Support