Formatting a Date

[dbielenda]

I have this formula to get a date:

ToText({PURP110B.EXREMB}, 0) + "/" + ToText({PURP100B.EXREDB}, 0) + "/" + ToText({PURP100B.EXREYB}, 0, '','' )

Th date is displayed on the report as : 1/8/2002

How can I have the date be displayed as : 1/8/02??

Thank you!

 

[horizon2000]

Dibielenda,

If PURP100B.EXRYB has contain 4 digits then try this one:
ToText({PURP110B.EXREMB}, 0) + "/" + ToText({PURP100B.EXREDB}, 0) + "/" + Right(ToText({PURP100B.EXREYB}, 0, '','' ),2)

Robert

 

[dbielenda]

Worked great! Thanks Robert s-)

 

[dgillz]

Is your date really a text field? I don't understand why you don't just right click-format field. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office