Import Actual Fiscal Weeks

Question

I would like to run an automation of sorts, where a user inputs a year into a parent table and then i would like to run an automation that creates 52 children records for fiscal weeks. Outside of just having a number 1 thru 52, is it possible to have the actual fiscal date of that year populate into a field so that i can do reporting off of that?

As the fiscal week changes each year, not sure if quickbase's native formulas could cover this.

------------------------------
Rob Salaj
------------------------------

MarkShnierYou · Answer

Yes, this is possible. Can you explain what the rule is for determining what the fiscal week is for each of the 52 weeks? Is this like the Sunday of when the week begins? If so can you explain what the rules are for that and also do you have to deal with years that have 53 weeks.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community