Create an unique ID in Infopath with Date Format - InfoPath Dev
in

InfoPath Dev

Create an unique ID in Infopath with Date Format

Last post 01-15-2014 07:22 AM by Hilary Stoupa. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-13-2014 06:40 AM

    Create an unique ID in Infopath with Date Format

    Hey guys,

    I've got a question. I would like to know how I could create an unique ID in InfoPath 2010 uses also the date, e.g. it should look like that 2013/1 next year or this year 2014/1

    How could I achieve that!

    Best regards

    Matthias 

  • 01-15-2014 01:18 AM In reply to

    • L Mac
    • Not Ranked
    • Joined on 01-15-2014
    • PNG
    • Posts 16

    Re: Create an unique ID in Infopath with Date Format

     I create unique numbers for forms using the following:

    concat(substring(xdDate:Now(), 0, 5), substring(xdDate:Now(), 6, 2), substring(xdDate:Now(), 9, 2), substring(xdDate:Now(), 12, 2), substring(xdDate:Now(), 15, 2), substring(xdDate:Now(), 18, 2))

    This returns date and time converted to a number  i.e. 20140115191523

    Play around with this, just display those parts that you require.

    Hope this helps.

    L Mac

  • 01-15-2014 07:22 AM In reply to

    Re: Create an unique ID in Infopath with Date Format

    Hey, L Mac - you could also use translate to do this:

    translate(now(), "T:-", "")

    Hilary Stoupa

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.