Hi there,
I am using the following formula to get the last day of the previous month and if the value of {?AsofDate} is April 30, 2002, then it returns March 30, 2002, instead of March 31, 2002.
Any reason this might happen?
Formula:
DateAdd("m", -1, {?Pm-?AsOfDate})
I am using the following formula to get the last day of the previous month and if the value of {?AsofDate} is April 30, 2002, then it returns March 30, 2002, instead of March 31, 2002.
Any reason this might happen?
Formula:
DateAdd("m", -1, {?Pm-?AsOfDate})