Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have to calcul rate and i use this in the script :
(sum(value)/ day((Date)) ) as Rate
Now i need to replace day(date) by the last day of the month
Thanks for help
Regards
May be this:
Sum(value)/Day(MonthEnd(Date)) AS Rate
Regards!
Rahul