local variable date format

Author: osieman@gmail.com (osie_osie)

A local variable($lv_date$) with display format = DIS(yyyy-mm-dd)

I then put this into a where clause
"where br_from_dt >= '%%$lv_date$%%%'"

before it would display as where br_from_dt >= '2010-06-30'
but now it shows as where br_from_dt >= '201006-30'


Temporary workaround from Uli:

Add an extra '-'

Use DIS(yyyy--mm-dd) ??



  1. Posted:

    13.06.10 11:32

       by osie

    Cheers Uli.. that did the trick.

    Author: ulrich-merkel (ulrichmerkel@web.de)
  2. Hi osman,

    The described problem looks like the issue described in the bug report 28663 "Date layout DIS(yyyy-mm-dd) works incorrectly", which is Uniface 9.4-specific. Is it correct that you're encountering this matter after migrating to (or whlle using) version 9.4? The good news is that this issue should be resolved with the patch R102, which should be released in the course of this week.

    Hope this helps.

    Best regards,

    *** Usual disclaimer ***


    Author: diseli (daniel.iseli@uniface.com)