# Input problem with Date field

**URL:** <https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, NaturalONE, Natural-for-AJAX\
**Created:** [August 10, 2011, 2:32pm UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984 "2011-08-10T14:32:58Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Werner\_Bredenhann](https://avatars.discourse-cdn.com/v4/letter/w/a4c791/32.png) [@Werner\_Bredenhann](https://techcommunity.softwareag.com/u/Werner_Bredenhann)\
**Post date:** [August 10, 2011, 2:32pm UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984/1 "2011-08-10T14:32:58Z")

</div>

I have a field on a Page formatted as a Date (D). Automatically there is an Auto Popup calendar where one can choose a date.

However, for some reason one cannot manually enter a date (in the format YYYY-MM-DD), as displayed when selecting from the calendar.

As soon as one enters another character after YYYY, the field is cleared.

---

<div class="post-metadata">

**Author:** ![Steve\_Robinson](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/steve_robinson/32/107_2.png) [@Steve\_Robinson](https://techcommunity.softwareag.com/u/Steve_Robinson)\
**Post date:** [August 10, 2011, 4:30pm UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984/2 "2011-08-10T16:30:06Z")

</div>

Whose popup calendar are you working with? Natural’s, Microsofts, homegrown?

Check your settings for the various Date parameters (e.g. DTFORM, DF).

steve

---

<div class="post-metadata">

**Author:** ![Werner\_Bredenhann](https://avatars.discourse-cdn.com/v4/letter/w/a4c791/32.png) [@Werner\_Bredenhann](https://techcommunity.softwareag.com/u/Werner_Bredenhann)\
**Post date:** [August 10, 2011, 6:33pm UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984/3 "2011-08-10T18:33:58Z")

</div>

We are using the stock standard Natural popup calender (there seems to be two of them, one for a field declared as a Date, and another for the Date Control - they certainly look slightly different on the two controls).

The DBA’s inform me that neither the DTFORM , nor the DF parameters are set on either the mainframe or the NDV. They are assuming it will then be the default value.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [August 10, 2011, 8:18pm UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984/4 "2011-08-10T20:18:30Z")

</div>

What’s the datatype on the page ?

---

<div class="post-metadata">

**Author:** ![Werner\_Bredenhann](https://avatars.discourse-cdn.com/v4/letter/w/a4c791/32.png) [@Werner\_Bredenhann](https://techcommunity.softwareag.com/u/Werner_Bredenhann)\
**Post date:** [August 11, 2011, 12:43pm UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984/5 "2011-08-11T12:43:31Z")

</div>

The field is declared as a DATE field.

When selecting a date from the PopUp calender, it appears in the field as YYYY-MM-DD. I’ve specified an Edit Mask (YYYY-MM-DD) on the field, but then one looses the Auto PoUp Calender.

The reason I don’t use the DATE control, is because there is no Display Property on that control (which a normal field has).

---

<div class="post-metadata">

**Author:** ![Steve\_Robinson](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/steve_robinson/32/107_2.png) [@Steve\_Robinson](https://techcommunity.softwareag.com/u/Steve_Robinson)\
**Post date:** [August 11, 2011, 3:57pm UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984/6 "2011-08-11T15:57:30Z")

</div>

The default value for DF is S, which is YY-MM-DD. Do you actually get 4 characters before the field is cleared?

Bribe the DBAs with a Castle, always seems to work. Find out what the values are.

Read the writeup of the popup calendar to see what format it assumes.

steve

---

<div class="post-metadata">

**Author:** ![Werner\_Bredenhann](https://avatars.discourse-cdn.com/v4/letter/w/a4c791/32.png) [@Werner\_Bredenhann](https://techcommunity.softwareag.com/u/Werner_Bredenhann)\
**Post date:** [August 11, 2011, 6:59pm UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984/7 "2011-08-11T18:59:45Z")

</div>

Steve

Thank you! Using the default format solves the issue. We will override that in the NDV and NWO to match the output format (YYYY-MM-DD).

I’m pleasantly surprised to see you have some knowledge about an essential part of South African culture :o

Cheers!

Werner

---

<div class="post-metadata">

**Author:** ![Steve\_Robinson](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/steve_robinson/32/107_2.png) [@Steve\_Robinson](https://techcommunity.softwareag.com/u/Steve_Robinson)\
**Post date:** [August 11, 2011, 11:16pm UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984/8 "2011-08-11T23:16:00Z")

</div>

From 1990 to 2000 I averaged two trips a year of 2-3 weeks duration to South Africa to teach Natural. Since then I have been there sporadically (although in 2008 I made 5 trips for a total of 9 weeks).

I have more than knowledge re Castle; lots of first hand experience.

javascript:emoticon(‘:D’)

😃

steve

---

<div class="post-metadata">

**Author:** ![Jan\_Van\_Achter](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/jan_van_achter/32/164_2.png) [@Jan\_Van\_Achter](https://techcommunity.softwareag.com/u/Jan_Van_Achter)\
**Post date:** [October 13, 2011, 10:37am UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984/9 "2011-10-13T10:37:17Z")

</div>

You can also specify the DTFORM parameter in the NWO.bat or NWO.sh file that is used to initiate the natural session.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:00pm UTC](https://techcommunity.softwareag.com/t/input-problem-with-date-field/97984/10 "2021-04-02T15:00:43Z")

</div>


