To_Date Function When Date Field is a Quarter

  • 3 August 2022
  • 0 replies

I am trying to find the dollar variance between two quarters. When I have my date field in months in a pivot, I can easily use the “to_date” function in combination with pivot_where to calculate the variance between two months. However, when I go to roll this up to the quarter, it seems like the “to_date” function does not recognize quarters. Help resolving this would be much appreciated. I am not sure if I need to use another function?



0 replies

Be the first to reply!