Duplicate separate Data and Time into One Data and Time Field - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Duplicate separate Data and Time into One Data and Time Field

Last post 05-24-2021 09:22 AM by Wanzer316. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-24-2021 07:17 AM

    Duplicate separate Data and Time into One Data and Time Field

    I am trying to duplicate the data and time from separate fields into one data and time field. Does anyone know how I can do this easily?
    Filed under:
  • 05-24-2021 08:16 AM In reply to

    Re: Duplicate separate Data and Time into One Data and Time Field

    If your Date and your Time fields always have data, your new date time field could use a concat formula for its default value: concat(datefield, "T", timefield)

    If they don't both always have data, you may want to use rules for this instead. Add a rule on the date field to set the new date time field using a formula like the one above, if time has a value. If time doesn't have a value, you could set the date time field to blank, or use: concat(datefield, "T00:00:00") for a blank time. On the time field, you'd also need rules to set the new date time field. You may also need rules in the Form Load rules to set the new field according to whatever logic you need (that is, whatever you decide should happen if one of the two fields has no data).  

    Hilary Stoupa

  • 05-24-2021 09:22 AM In reply to

    Re: Duplicate separate Data and Time into One Data and Time Field

    Thank you! I will try that today to see if it works.
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.