Split Time

[Drum2001]

I currently have a Time/Date Field. Is there anyway to "split" the
hours and mins into two separate text boxes on a clicked command
button?

For example:

TimeFieldFull: [ 10:23 ] -----> TimeHours [ 10 ] , TimeMins [ 23 ]

Thank you!

Brad

[AP]

Re: Split Time


Hello
Try datepart("h",[datefield]) for the hour
and Datepart("n",[datefield]) for the minute.


Drum2001 wrote:[color=blue]
> I currently have a Time/Date Field. Is there anyway to "split" the
> hours and mins into two separate text boxes on a clicked command
> button?
>
> For example:
>
> TimeFieldFull: [ 10:23 ] -----> TimeHours [ 10 ] , TimeMins [ 23 ]
>
> Thank you!
>
> Brad[/color]

[Drum2001]

Re: Split Time

THAT DID THE TRICK!!!!

THANK YOU VERY MUCH!!!


AP wrote:[color=blue]
> Hello
> Try datepart("h",[datefield]) for the hour
> and Datepart("n",[datefield]) for the minute.
>
>
> Drum2001 wrote:[color=green]
> > I currently have a Time/Date Field. Is there anyway to "split" the
> > hours and mins into two separate text boxes on a clicked command
> > button?
> >
> > For example:
> >
> > TimeFieldFull: [ 10:23 ] -----> TimeHours [ 10 ] , TimeMins [ 23 ]
> >
> > Thank you!
> >
> > Brad[/color][/color]