Re: Separate Date & Time in Forms 4.5

u can create a non-base table item in the same block and mirror with the date field and in the
format mask of the non base table item give the format mask as hh:mi:ss that will display the time
and the date field will have mm/dd/yy or appropriate date format. when u want to query based on the
time u can modify the pre-query trigger appropriately

DanHW wrote:

> >I'm writing an application in a Windows NT 4.0 environment. I have a
> >date field that I want to display as two separate items. That is
> >I want the date portion to show up as one item, and the time portion
> >to show up as a separate item. The users will lauch queries based on
> >date, and occassionally on date & time. Is there an easy way to
> >accomplish this?
> >
> >Ed Jennings
>
> If you are using a view for the base table, it's real easy - just modify the
> view definition to return the appropriate pieces (ie using the TRUNC). You will
> need to make the update statement splice them back together.
>
> If you are not using a view for the base table, use a pre-query trigger see how
> much info the user has supplied, and modify the query to use 'between' or
> 'trunc' or something.
>
> Hope that helps
>
> Dan

--
Balaraman Arvind
151 Andrew Ave, Apt 215
Naugatuck, CT 06770

ph   -  (203)-723-1190(R)
     -  (203)-459-7502(O)

mail -  dnivra_at_ix.netcom.com (R)
        abalaram_at_oxhp.com    (O)