Converting day into a current date

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
consume2
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

Converting day into a current date

Post by consume2 » Fri Dec 28, 2001 2:42 pm

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?

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> Converting day into a current date

Post by kfleming » Sun Dec 30, 2001 11:35 am

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

Post Reply