How to get Date time format in AutoSearch criteria?

rbuser

Hi,

I need to get DateTime format in a user report for a Field in AutoSearch
Criteria?

The component only show the date and Calendar dialog, but not the time.

Some like this: mm/dd/yyyy hh:nn:ss

Thanks!

nicocizik

Hi Guillermo,

The autosearch dialog will allow you to adjust the time if the initial
datetime value contains a time. For instance, inside the data view in the
data workspace if you set up an autosearch field to search on the date
11/10/2008, you will only be able to select a date. If however you search
on the date and time 11/10/2008 12:00:00 PM, you will be able to select a
date and time.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Nico,

The DateTime dialog in AutoSearch Criteria, is not working!
Only Show the Date.
Don't show the time: hh:nn:ss.

With the System hour zone, format dd/mm/yyyy it have an error.
I'm working with the TimeZone for LatinAmerica


Thanks a lot,

Sorry for my english

Guillermo

nicocizik

Hi Guillermo,

Which version of ReportBuilder and Delphi are you using? We made some
enhancements for the latest version (RB 11.01).

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Nico,

Yes, I've the latest version (RB 11.01).

Guillermo,

nardmoseley

Try using dd/MM/yyyy

The DateTimePicker is a Windows control and in Windows 'mm' is minutes and
'MM' is month. Check your Windows regional settings and check your Delphi
ShortDateFormat uses 'MM' for month and not 'mm'.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Nard:

Ok with the error! It's working!

Thanks, but I need in the Dialog Box get the Time in an AutoSearchCriteria
Field.

The Dialog Box only show the date.

I need something like this: dd/MM/yyy hh:mm:ss.

Thanks a lot!

Guillermo.

nardmoseley

> I need something like this: dd/MM/yyy hh:mm:ss.

1. Make sure are you are assigning a default search value that includes the
date /and/ time.

2. Check the value of the Delphi globals - ShortDateFormat and
ShortTimeformat

Internally Autosearch will detect the presence of time and use the
ShortDateFormat and ShortTimeformat to format the value to include the date
and time, as you describe.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com