• 1 reply
  • Latest Post - ‏2010-10-18T16:29:29Z by SystemAdmin
1 Post

Pinned topic Date translation

‏2010-10-18T15:37:24Z |
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
    557 Posts

    Re: Date translation

    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.