This topic has been locked.
1 reply Latest Post - 2010-10-18T16:29:29Z by SystemAdmin
Pinned topic Date translation
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
how do I translate WPF date (yyyy-MM-dd) to db2 date (yyyyMMdd). I need to remove the dashes. Using a dojo date builder.
Updated on 2010-10-18T16:29:29Z at 2010-10-18T16:29:29Z by SystemAdmin
SystemAdmin 110000D4XK557 PostsACCEPTED ANSWER
Re: Date translation2010-10-18T16:29:29Z in response to GeorgeMuhammadThe quick way to do it for a single field is to
1. put a Data Field Modifier on the field,
2. In the Formatter section select the StandardFormatter
3. Choose Format(Data$Display) and Translate(Data$Display).
The argument that these both take is, in your case, yyyyMMdd$yyyy-MM-dd
You can set these as your formatter and translater in an RDD file. If you are using Factory 7.0, you can set it up in your default RDD file so that all date fields will automatically get this behavior.