J
James Palmer
Guest
dtFirstOfMonth = dtDate - (day(dtDate) - 1). dtLastOfMonth = add-interval(dtFirstOfMonth,1,"month") - 1. That's probably a more elegant solution. How would you work out the first and last dates in a quarter on paper? I'm asking because the term 'quarter' seems to vary from country to country. Also, working out how you would do it on paper is a good step to solving it in code.
Continue reading...
Continue reading...