Forum Discussion

mikep7521's avatar
mikep7521
Helper III
8 years ago
Solved

Week Number for a certain date

I'm attempting to create a column/measure that captures what weeknum a certain date is in but i'm not receiving the correct answer. Below is my column and measure formula: Column Est. Close Date We...
Need Help
  • mikep7521's avatar
    mikep7521
    8 years ago

    I figured out the issue. There were multiple installments that had the same closing date whcih is what was leading to the wrong values being displayed. 

RMDNA's avatar
RMDNA
Solution Sage
8 years ago

Hi mikep7521,

 

Can you do it in the back end, or does it need to be a measure? I would just use "Column from Example" in Query Editor; it should pick up the pattern after a few entries.

mikep7521's avatar
mikep7521
Helper III
8 years ago

It does not need to be a column