Changing the appearance of a Date

[10four]

In my report I have a birth date field that displays the dates as 1968-22-10. I need it to display 10/22/68. I can't just format the field to look like that because it's set up as a character in the database and not as a date time field. Any help would be great.

Thanks

 

[mbarron]

Use the following formula to convert your field to a date.

stringvar dat:={your.date.field}
date(val(dat[1 to 4]),val(dat[9 to 10]),val(dat[6 to 7])) Mike

 

[technonurse]

I had this same problem since our database also displays year first. I solved with the formula that follows:

{date.field}[5 to 6] + "/"+
{date.field}[7 to 8] + "/"+
{date.field}[1 to 4]

 

[synapsevampire]

Consider converting it to a proper date (and evicerating your DBA )

cdate({date.field}[1 to 4]+"/"+{date.field}[9 to 10]+"/"+{date.field}[6 to 7]))

You may find better performance by offloading this function to your database using a SQL Expression, if that's a concern.

Converting allows for formatting a real date field and also allows for proper date functions (sorting, date arithmetic, etc.).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com