Filling up a time field - InfoPath Dev
in

InfoPath Dev

Filling up a time field

Last post 08-23-2007 04:36 AM by stumbler. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 08-23-2007 02:08 AM

    Filling up a time field

    I try to fill up a time field with a rule: @from_Hour = number("08:00") I recieve a 'NaN' error on my form.

    How can I avoid this error?

     

    Hans.
    Infopath 2003 / Jscript
  • 08-23-2007 02:44 AM In reply to

    Re: Filling up a time field

    Hello

    Is the data type and the format of the time field set correctly?

    Kalyan G Reddy
    Infopath MVP 2007 and 2008
  • 08-23-2007 03:06 AM In reply to

    Re: Filling up a time field

    Thanks for the response

    the form works against an SQL table.
    the data format of the field is datetime.
    the format on the form is identical to the whatever is typed in "99:99".

    Hans.
    Infopath 2003 / Jscript
  • 08-23-2007 03:21 AM In reply to

    Re: Filling up a time field

    You are using number() there, you dont need to use that. Just set "08:00:00". It will work.

  • 08-23-2007 04:36 AM In reply to

    Re: Filling up a time field

    Still not working! some background information: I use a datafield AMPM to determin start en stop hour. In the form there are 3 option buttons for AM / PM / All day.  according to the choice, i try to fill in a default start and stop time (that can be overwritten) with a rule. After the rule, I get the 'invalid data' indicator, instead of the the correct time. If I type in the same time as is shown in the field, the form accepts it. Any idea?

     

    Hans.
    Infopath 2003 / Jscript
Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.