how to get a value of last week in a quarter

Options
anilp
anilp Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 New Contributor

please help.

 

we have scenario to get the value of a numbered field of last week in a quarter. For example we are in Q 1, we want the value of week 13 (which is last week in first quarter). 

do we have any functions available to get the value?

Comments

  • anilp
    anilp Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 New Contributor

    Thank you anirudh for reply.

    that helps a bit. how i can identify last month in a quarter and based on that i need to pull the closing balance for that month.