Tactic for filtering by month.. - InfoPath Dev
in

InfoPath Dev

Tactic for filtering by month..

Last post 11-02-2010 11:55 AM by Desmo. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 11-02-2010 11:55 AM

    • Desmo
    • Not Ranked
    • Joined on 09-17-2009
    • Posts 14

    Tactic for filtering by month..

     For anyone struggling w/ a way to filter a repeating section by month in IP 2003, I wanted to share this

    Assuming your date record is called StartDate

    Create a data field called "ShowPeriod"  as a whole number (integer)
    Create a drop down w/ values  1-12 and corresponding labels Jan - Dec

    On repeating section, add the following expression to a filter

     contains(substring(@StartDate, 6, 2), ../../my:Showperiod)

      Thanks,

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