replacement of date seperators 1

[QueSpr04]

I am using CR10 w/ODBC[RDO] connection. But however connection has nothing to do with the small problem I am having. The format that CR10 gives for date seperators is a "/" sign, what I need is the "-" sign as a seperator. When I go into the format editor to change the style, it only gives me the option of "/" and "none", but it also has a formula button along side the seperator's column there for me to go in and make some conditional changes. Once I go into the formula editor, what code would I use to change the seperator from a "/" to a "-"?

 

[synapsevampire]

This must be new to CR 10, CR 8.5 allowed you to type in the separator of interest.

A simple means might be to use a formula such as:

replace(totext(currentdate),"/","-")

Use this for display purposes only, not sorting/grouping/date functionality.

-k

 

[QueSpr04]

Thanx synapsevampire!