Formula Help
Hello,
I have a question needing help with a formula. I have a field called "Start Date" and whatever date I put in that field I want it to auto-populate 3 other fields called "Week", "Month" and "Year". So if I put todays date in the "Start Date" field it would show 7 since its the 7th "Week" in the calendar year and would show 2 in the "Month" field (February is 2nd Month in the year) and show 2022 in the "Year" field. Any help to create this formula would be appreciated.
Thanks,
Derek
------------------------------
Derek Pipal
------------------------------
I have a question needing help with a formula. I have a field called "Start Date" and whatever date I put in that field I want it to auto-populate 3 other fields called "Week", "Month" and "Year". So if I put todays date in the "Start Date" field it would show 7 since its the 7th "Week" in the calendar year and would show 2 in the "Month" field (February is 2nd Month in the year) and show 2022 in the "Year" field. Any help to create this formula would be appreciated.
Thanks,
Derek
------------------------------
Derek Pipal
------------------------------
