I am trying to get a field to fill in with a "DD" one week and a "FF" the other week and alternate "DD" to "FF" every week. I want the field to fill in when the report is opened for editing.
Is there a way to have the field filled in with the "DD" on even weeks and the "FF" on odd weeks? If yes, what commands would i have to use or how would i write the script to accomplish this?
Thank you for any helpful suggestions.