AnsweredAssumed Answered

Analyses to find last day of the month

Question asked by Boost01 on Nov 17, 2016
Latest reply on Mar 26, 2020 by jamesbrandt

Hi All,


I am trying to set up some Analyses to create test data, and one of the things I have been asked to do is generate specific data if Today = last day of month


I can use the Day('*') to find out what day it is, but how would I determine which of the 4 possible last days it is?

I can find the month, knowing how many days there are figure it that way, but it seems a long way around. Is there a easier way?