Converting Date to proper format in formula 1

[Delphin]

I have a formula the shows 2 dates from a table:
Date ({invdetail;1.InvStartdt}) & " to " & date({invdetail;1.InvEndDt})

Since I cannot format the dates to look like 01/02/04 to 01/31/04 via text formatting, how do I get them to stap printing out as 1/2/04. all of the conversions I know either have too many arguments or not enough.

 

[lbass]

Why can't you use totext()? Try:

totext(Date({invdetail;1.InvStartdt}),"MM/dd/yy") + " to " +
totext(date({invdetail;1.InvEndDt}),"MM/dd/yy")

-LB

 

[Delphin]

thanks... didn't even think about converting it to text first.

Billy Ballard

For in the past, Lies the future.