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 Posts
Re: Date translation2010-10-18T16:29:29ZThis is the accepted answer. This is the accepted answer.The 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.