I have a Secondary List(B) that my Primary List(A) uses to populate a field in InfoPath called 'Current Pay Period' which is a drop down. List B contains a calculated column to display dates since the Date Picker does not work as a LookUp Field. Initially, I set a Retention Policy on List B to delete entries [dates] that were older than one month so that the user has current dates in the InfoPath form to choose. Unfortunately, I forgot that deleting those items means older entries in List A with past dates will now have a blank entry.
Is there a way to filter the Current Pay Period drop down to only show dates for the Current Month in List A with jQuery - or only show future dates?
My assumption is that I'd have to write a script to get the currentDate and currentMonth, write an equation to determine if currentDate is still within the currentMonth, then use jquery's filter method to filter the options in the dropdown.