I had a similar problem with DateTime. Glad to see this post -- thought I was going crazy!

I wasn't try to give anyone Cardiac Arrest   I just knew that we have a number of people that were needing some enhancements so while I was in there, I made every change that was on my list.  Glad it got you what you needed

I would advice them to take a bit longer next time, and give you the news slower, in parts...

Seriously, now, I agree with you, it was an amazing work! As usual...

Hi Trent, Ben,

Well, there is not need to answer my previous request

I found the answer on this post: http://forum.strataframe.net/Topic12630-22-1.aspx and I you guys took me by surprise, I almost have a heart attach, when I saw the details for the update.

Thanks a lot for such a response.

Edhy Rijo

Hi Trent, Ben,

Is there any news on this issue?

I really need to have a Date range functionality in the Browser Dialog for this particular form. 

The customer wants to be able to search for records and I need to provide him with an answer.

At this point I am open to any suggestion.  The fields are DateTime, but in the Browser Dialog search I just need to use the date.

Thanks!

Edhy Rijo

Hi Trent,

Since when using a DateTime search field in the Browser Dialog, it wll only show the Date part instead of the DateTime, could it be possible incorporate a quick fix like this:

When using the filter expression on a DateTime search field like:

• >= SF modify the time part to be 12:00 AM
• <= SF modify the time part to be 11:59:29 PM

This will produce the correct SQL statement needed by the Dialog Browser to get the correct records.

I truly believe that the way the DB works now with date should be doing something like this under the hook.  Please consider this and let me know.

Thanks!

Edhy Rijo

Well, this really isn't an option since the field in the table is a DateTime.  You can use some functions in SQL Server to ignore the time, but this slows the query, and is not the same for all databases.  This is on our "to-look-at" list.

Hi Trent,

You are right on the spot, the datetime data stored in the database is 10/16/2007 10:30:00pm, by changing the ending time to 17th I was able to get the correct record in the browser dialog.  The situation is that we don't have any way change the value of the controls in the BD other than the InitialValue, guess we need more hooks to handle this kind of situation.

About the enhancement, I would prefer to deal only with the date part instead of date and time, so you can maybe add a new option in the Search Field Criteria form to handle Date Ranges and internally modify the time from 12:00:00 AM to 11:59:59 PM of the user's selected date ranges.

Please let me know your plans on this, since I do really need to provide the end use with a way to search on records for specific date in this form.

Edhy Rijo

Edhy,

I think I know what is going on here.  If you change the ending time to the 17th, do any records show up?  I think that this has to do with the time.  By default, a DateTime has both parts, a date value and a time value and I do not think that the time is being ignore.  I think by default the time is cleared out so it would be midnight.  So in your example, the query is actually trying to search by this:

So as you could see, unless there was an actual call placed at exactly midnight on the 16th, a record will no appear.  There probably needs to be an enhancement that allows the time to be specified along with the date versus always clearing to midnight.  For example, you would either choose clear to midnight or set to the end of the day (11:59:59 PM).  This way you would not have this particular issue.

Hi Ben, Trent,

Could you please check this problem above.

Thanks!

Edhy Rijo