Hi,
I have a field called 'Audit Date' and 'Period'. I would like the 'Period' field to automatically the period number if the audit date entered in the 'Audit Date' field is between a certain date range.
Below is the date ranges and period numbers
30-04-2017 - 27-05-2017 = Period 1
28-05-2017 - 24-06-2017 = Period 2
25-06-2017 - 29-07-2017 = Period 3
30-07-2017 - 26-08-2017 = Period 4
27-08-2017 - 23-09-2017 = Period 5
24-09-2017 - 28-10-2017 = Period 6
29-10-2017 - 25-11-2017 = Period 7
28-11-2017 - 30-12-2017 = Period 8
31-12-2017 - 27-01-2018 = Period 9
28-01-2018 - 24-02-2018 = Period 10
25-02-2018 - 24-03-2018 = Period 11
25-03-2018 - 28-04-2018 = Period 12
So if the users inputs the date 10-05-2017 in the 'Audit Date' field the 'Period' field should change to 'Period 1'.
Any ideas on how this can be achieved would greatly appreciated.
Regards,
Craig
I have a field called 'Audit Date' and 'Period'. I would like the 'Period' field to automatically the period number if the audit date entered in the 'Audit Date' field is between a certain date range.
Below is the date ranges and period numbers
30-04-2017 - 27-05-2017 = Period 1
28-05-2017 - 24-06-2017 = Period 2
25-06-2017 - 29-07-2017 = Period 3
30-07-2017 - 26-08-2017 = Period 4
27-08-2017 - 23-09-2017 = Period 5
24-09-2017 - 28-10-2017 = Period 6
29-10-2017 - 25-11-2017 = Period 7
28-11-2017 - 30-12-2017 = Period 8
31-12-2017 - 27-01-2018 = Period 9
28-01-2018 - 24-02-2018 = Period 10
25-02-2018 - 24-03-2018 = Period 11
25-03-2018 - 28-04-2018 = Period 12
So if the users inputs the date 10-05-2017 in the 'Audit Date' field the 'Period' field should change to 'Period 1'.
Any ideas on how this can be achieved would greatly appreciated.
Regards,
Craig