# Can't edit dates when not using mm/dd/yyyy date format for display

**URL:** <https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [November 9, 2009, 6:19pm UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951 "2009-11-09T18:19:39Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 9, 2009, 6:19pm UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/1 "2009-11-09T18:19:39Z")

</div>

Hello Toad Team;

Using 10.1, I get a Toad exception (i.e. not an oracle error but the ‘Error occurred’ popup with the call stack) if I try to update a date in an editable data grid when I don’t have mm/dd/yyyy specified as my date format in the data grid options. I didn’t test all the formats, but I normally use yyyy/mm/dd as my date format and that generates the error, and so does dd/mm/yyyy so I’m guessing the data grid is not taking into account the display format in use when updating. Let me know if this can’t be reproduced or if it could somehow be due to a config problem.

Happy Monday,  
Troy

EurekaLog 6.0.20

Application:

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 11, 2009, 3:37am UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/2 "2009-11-11T03:37:16Z")

</div>

Hi all,  
I’m using Toad for Oracle Xpert ver.9.7.2.5 with db admin module.  
Problem is that ;when I connect as SYS with sysdba priviliges, but not able to see the icon images Lock/Expire on the left of every USER(s) in the schema browser. I checked/unchecked browser style option “Show LHS Item Images” very many times but makes no change except “Img” column’s appearing & disappearing. When I click on “Img” column , the label “Img” disappears and instead down/up arrow leaves back.  
I’ve searched Quest’s Knowledge base and tried all recommended issues and no improvement at all !!.  
Before 9.7 , Toad can do this and it’s was a great feature actually.  
Will you kindly help me with my problem, otherwise it’s really a bargain to find out which user is locked/expired.

Regards,  
Tülin Riva

Hello Toad Team;

Using 10.1, I get a Toad exception (i.e. not an oracle error but the ‘Error occurred’ popup with the call stack) if I try to update a date in an editable data grid when I don’t have mm/dd/yyyy specified as my date format in the data grid options. I didn’t test all the formats, but I normally use yyyy/mm/dd as my date format and that generates the error, and so does dd/mm/yyyy so I’m guessing the data grid is not taking into account the display format in use when updating. Let me know if this can’t be reproduced or if it could somehow be due to a config problem.

Happy Monday,  
Troy

EurekaLog 6.0.20

Application:

Hi all,

I’m using Toad for Oracle Xpert ver.9.7.2.5 with db admin module.

Problem is that ;when I connect as SYS with sysdba priviliges, but not able to  
see the icon images Lock/Expire on the left of every USER(s) in the schema  
browser. I checked/unchecked browser style option “Show LHS Item Images” very  
many times but makes no change except “Img” column’s appearing & disappearing.  
When I click on “Img” column , the label “Img” disappears and instead down/up  
arrow leaves back.

I’ve searched Quest’s Knowledge base and tried all recommended issues and no  
improvement at all !!.

Before 9.7 , Toad can do this and it’s was a great feature actually.

Will you kindly help me with my problem, otherwise it’s really a bargain to find  
out which user is locked/expired.

Regards,

Tülin Riva

Hello Toad Team;

Using 10.1, I get a Toad exception (i.e. not an oracle error but the ‘Error  
occurred’ popup with the call stack) if I try to update a date in an editable  
data grid when I don’t have mm/dd/yyyy specified as my date format in the data  
grid options. I didn’t test all the formats, but I normally use yyyy/mm/dd as my  
date format and that generates the error, and so does dd/mm/yyyy so I’m guessing  
the data grid is not taking into account the display format in use when  
updating. Let me know if this can’t be reproduced or if it could somehow be due  
to a config problem.

Happy Monday,  
Troy

EurekaLog 6.0.20

Application:

* * *

1.1 Start Date : Thu, 5 Nov 2009 15:18:16 -0600  
1.2 Name/Description: Toad.exe - (Toad for Oracle)  
1.3 Version Number : 10.1.0.7  
1.4 Parameters :  
1.5 Compilation Date: Fri, 23 Oct 2009 12:57:05 -0600  
1.6 Up Time : 4 days, 2 hours, 42 minutes, 44 seconds

Exception:

* * *

2.1 Date : Mon, 9 Nov 2009 18:01:00 -0600  
2.2 Address : 006E8B21  
2.3 Module Name : Toad.exe - (Toad for Oracle)  
2.4 Module Version: 10.1.0.7  
2.5 Type : EcxEditValidationEr ror  
2.6 Message : Invalid Date.  
2.7 ID : 5DEE  
2.8 Count : 1  
2.9 Status : New  
2.10 Note :  
 ![image004.gif](https://global.discourse-cdn.com/quest/original/1X/41f8730228f3026bfff01444752384c5c40770f4.gif)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 11, 2009, 3:37am UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/3 "2009-11-11T03:37:16Z")

</div>

Hi all,  
I’m using Toad for Oracle Xpert ver.9.7.2.5 with db admin module.  
Problem is that ;when I connect as SYS with sysdba priviliges, but not able to see the icon images Lock/Expire on the left of every USER(s) in the schema browser. I checked/unchecked browser style option “Show LHS Item Images” very many times but makes no change except “Img” column’s appearing & disappearing. When I click on “Img” column , the label “Img” disappears and instead down/up arrow leaves back.  
I’ve searched Quest’s Knowledge base and tried all recommended issues and no improvement at all !!.  
Before 9.7 , Toad can do this and it’s was a great feature actually.  
Will you kindly help me with my problem, otherwise it’s really a bargain to find out which user is locked/expired.

Regards,  
Tülin Riva

Hello Toad Team;

Using 10.1, I get a Toad exception (i.e. not an oracle error but the ‘Error occurred’ popup with the call stack) if I try to update a date in an editable data grid when I don’t have mm/dd/yyyy specified as my date format in the data grid options. I didn’t test all the formats, but I normally use yyyy/mm/dd as my date format and that generates the error, and so does dd/mm/yyyy so I’m guessing the data grid is not taking into account the display format in use when updating. Let me know if this can’t be reproduced or if it could somehow be due to a config problem.

Happy Monday,  
Troy

EurekaLog 6.0.20

Application:

Hi all,

I’m using Toad for Oracle Xpert ver.9.7.2.5 with db admin module.

Problem is that ;when I connect as SYS with sysdba priviliges, but not able to  
see the icon images Lock/Expire on the left of every USER(s) in the schema  
browser. I checked/unchecked browser style option “Show LHS Item Images” very  
many times but makes no change except “Img” column’s appearing & disappearing.  
When I click on “Img” column , the label “Img” disappears and instead down/up  
arrow leaves back.

I’ve searched Quest’s Knowledge base and tried all recommended issues and no  
improvement at all !!.

Before 9.7 , Toad can do this and it’s was a great feature actually.

Will you kindly help me with my problem, otherwise it’s really a bargain to find  
out which user is locked/expired.

Regards,

Tülin Riva

Hello Toad Team;

Using 10.1, I get a Toad exception (i.e. not an oracle error but the ‘Error  
occurred’ popup with the call stack) if I try to update a date in an editable  
data grid when I don’t have mm/dd/yyyy specified as my date format in the data  
grid options. I didn’t test all the formats, but I normally use yyyy/mm/dd as my  
date format and that generates the error, and so does dd/mm/yyyy so I’m guessing  
the data grid is not taking into account the display format in use when  
updating. Let me know if this can’t be reproduced or if it could somehow be due  
to a config problem.

Happy Monday,  
Troy

EurekaLog 6.0.20

Application:

* * *

1.1 Start Date : Thu, 5 Nov 2009 15:18:16 -0600  
1.2 Name/Description: Toad.exe - (Toad for Oracle)  
1.3 Version Number : 10.1.0.7  
1.4 Parameters :  
1.5 Compilation Date: Fri, 23 Oct 2009 12:57:05 -0600  
1.6 Up Time : 4 days, 2 hours, 42 minutes, 44 seconds

Exception:

* * *

2.1 Date : Mon, 9 Nov 2009 18:01:00 -0600  
2.2 Address : 006E8B21  
2.3 Module Name : Toad.exe - (Toad for Oracle)  
2.4 Module Version: 10.1.0.7  
2.5 Type : EcxEditValidationEr ror  
2.6 Message : Invalid Date.  
2.7 ID : 5DEE  
2.8 Count : 1  
2.9 Status : New  
2.10 Note :  
[att1.dat](https://global.discourse-cdn.com/quest/original/1X/2daeaa8b5f19f0bc209d976c02bd6acb51b00b0a.dat) (43 Bytes)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 11, 2009, 7:53am UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/4 "2009-11-11T07:53:19Z")

</div>

Hello Tulin,

The information for the image column comes from the “ACCOUNT\_STATUS” column  
of dba\_users. The first thing I would suggest is look at the filter icon (the  
one that looks like a funnel). If it is red, then click it and clear the  
filter.

Another idea is try this query logged in as SYS and another user. Does the  
value in the account\_status column change?

select username , account\_status

from dba\_Users

order by 1

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 11, 2009, 9:20am UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/5 "2009-11-11T09:20:46Z")

</div>

Hi John,  
I've cleared the filter icon and closed the SB and opened again. No images.  
Unchecked and checked browser style option . No images.  
As for the query it's successful, fetched the records with account status whatever they are.  
Could the images files missing somewhere or the image type problem ?  
below the screenshot of SB.

> > > On 11 November 2009 Wednesday at 15:53, in message , John Dorlon wrote:

Hello Tulin,  
The information for the image column comes from the “ACCOUNT\_STATUS” column of dba\_users. The first thing I would suggest is look at the filter icon (the one that looks like a funnel). If it is red, then click it and clear the filter.  
Another idea is try this query logged in as SYS and another user. Does the value in the account\_status column change?  
select username, account\_status  
from dba\_Users  
order by 1

Hi John,

I've cleared the filter icon and closed the SB and opened again. No images.

Unchecked and checked browser style option . No images.

As for the query it's successful, fetched the records with account status  
whatever they are.

Could the images files missing somewhere or the image type problem ?

below the screenshot of SB.

> > > On 11 November 2009 Wednesday at 15:53, in message  
> > > , John  
> > > Dorlon wrote:

Hello Tulin,

The information for the image column comes from the “ACCOUNT\_STATUS” column  
of dba\_users. The first thing I would suggest is look at the filter icon (the  
one that looks like a funnel). If it is red, then click it and clear the filter.

Another idea is try this query logged in as SYS and another user. Does the value  
in the account\_status column change?

select username , account\_status

from dba\_Users

order by 1  
[att1.dat](https://forums.toadworld.com/uploads/default/original/1X/e808551f3d97ce7f599c9889348c23f095b98f7e.dat) (3.91 MB)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 11, 2009, 9:20am UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/6 "2009-11-11T09:20:46Z")

</div>

Hi John,  
I've cleared the filter icon and closed the SB and opened again. No images.  
Unchecked and checked browser style option . No images.  
As for the query it's successful, fetched the records with account status whatever they are.  
Could the images files missing somewhere or the image type problem ?  
below the screenshot of SB.

> > > On 11 November 2009 Wednesday at 15:53, in message , John Dorlon wrote:

Hello Tulin,  
The information for the image column comes from the “ACCOUNT\_STATUS” column of dba\_users. The first thing I would suggest is look at the filter icon (the one that looks like a funnel). If it is red, then click it and clear the filter.  
Another idea is try this query logged in as SYS and another user. Does the value in the account\_status column change?  
select username, account\_status  
from dba\_Users  
order by 1

Hi John,

I've cleared the filter icon and closed the SB and opened again. No images.

Unchecked and checked browser style option . No images.

As for the query it's successful, fetched the records with account status  
whatever they are.

Could the images files missing somewhere or the image type problem ?

below the screenshot of SB.

> > > On 11 November 2009 Wednesday at 15:53, in message  
> > > , John  
> > > Dorlon wrote:

Hello Tulin,

The information for the image column comes from the “ACCOUNT\_STATUS” column  
of dba\_users. The first thing I would suggest is look at the filter icon (the  
one that looks like a funnel). If it is red, then click it and clear the filter.

Another idea is try this query logged in as SYS and another user. Does the value  
in the account\_status column change?

select username , account\_status

from dba\_Users

order by 1  
[att1.dat](https://forums.toadworld.com/uploads/default/original/1X/2daeaa8b5f19f0bc209d976c02bd6acb51b00b0a.dat) (43 Bytes)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 11, 2009, 9:20am UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/7 "2009-11-11T09:20:46Z")

</div>

Hi John,  
I've cleared the filter icon and closed the SB and opened again. No images.  
Unchecked and checked browser style option . No images.  
As for the query it's successful, fetched the records with account status whatever they are.  
Could the images files missing somewhere or the image type problem ?  
below the screenshot of SB.

> > > On 11 November 2009 Wednesday at 15:53, in message , John Dorlon wrote:

Hello Tulin,  
The information for the image column comes from the “ACCOUNT\_STATUS” column of dba\_users. The first thing I would suggest is look at the filter icon (the one that looks like a funnel). If it is red, then click it and clear the filter.  
Another idea is try this query logged in as SYS and another user. Does the value in the account\_status column change?  
select username, account\_status  
from dba\_Users  
order by 1

Hi John,

I've cleared the filter icon and closed the SB and opened again. No images.

Unchecked and checked browser style option . No images.

As for the query it's successful, fetched the records with account status  
whatever they are.

Could the images files missing somewhere or the image type problem ?

below the screenshot of SB.

> > > On 11 November 2009 Wednesday at 15:53, in message  
> > > , John  
> > > Dorlon wrote:

Hello Tulin,

The information for the image column comes from the “ACCOUNT\_STATUS” column  
of dba\_users. The first thing I would suggest is look at the filter icon (the  
one that looks like a funnel). If it is red, then click it and clear the filter.

Another idea is try this query logged in as SYS and another user. Does the value  
in the account\_status column change?

select username , account\_status

from dba\_Users

order by 1  
 ![image004.gif](https://global.discourse-cdn.com/quest/original/1X/41f8730228f3026bfff01444752384c5c40770f4.gif)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 11, 2009, 2:01pm UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/8 "2009-11-11T14:01:14Z")

</div>

Fixed for December patch.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 11, 2009, 2:17pm UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/9 "2009-11-11T14:17:26Z")

</div>

Merry Christ - err - Happy Holidays! We’ve fixed over 26 bugs for this patch and about 33 for the last patch. Who said we don’t do maintenance releases? 🙂

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 12, 2009, 8:24am UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/10 "2009-11-12T08:24:29Z")

</div>

Do you have the option under Startup - "Check for DBA views" checked? Looks like  
the query that is populating the SB is using all\_users instead of dba\_users.

Ed

[TeamT]

 ![ATT00232.jpg](https://global.discourse-cdn.com/quest/original/2X/8/82dd42cd93e1e3cf12269108744a2a8ce03ac3ce.bmp)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 12, 2009, 8:36am UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/11 "2009-11-12T08:36:43Z")

</div>

It does look that, Ed. I’ve been emailing Tulin offline. I have his  
Toad.ini and he has that option checked. I just asked for a spool sql.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [November 12, 2009, 9:11am UTC](https://forums.toadworld.com/t/cant-edit-dates-when-not-using-mm-dd-yyyy-date-format-for-display/8951/12 "2009-11-12T09:11:30Z")

</div>

Thanks Ed and John,

```
    In Toad Options, I've checked "Check for access to DBA views" (it was unchecked) then Icon images came back for USERS tab.

```

Again thanx for your kind help,

Regards,

> > > On 12 November 2009 Thursday at 16:36, in message , John Dorlon wrote:

It does look that, Ed. I’ve been emailing Tulin offline. I have his Toad.ini and he has that option checked. I just asked for a spool sql.

Thanks Ed and John,

In Toad Options, I've checked "Check for access to DBA views" (it was unchecked)  
then Icon images came back for USERS tab.

Again thanx for your kind help,

Regards,

> > > On 12 November 2009 Thursday at 16:36, in message  
> > > , John  
> > > Dorlon wrote:

It does look that, Ed. I’ve been emailing Tulin offline. I have his Toad.ini  
and he has that option checked. I just asked for a spool sql.  
[att1.dat](https://forums.toadworld.com/uploads/default/original/1X/2daeaa8b5f19f0bc209d976c02bd6acb51b00b0a.dat) (43 Bytes)