Getting the month (monthname function) and year (year function). The day is tricky since it can be a suffix of st, nd, rd or th. But a if or switch statement might work for this.
i.e., monthname(datefield)+ ' ' + totext(day(datefield))+if day(datefield) = 1 then 'st ' else if day(datefield) =2 then 'nd ' else if day(datefield) = 3 the 'rd ' else 'th ' +year(datefield) + ' through ' + (repeat the first part of the formula for the second datefield.
It's tricky since it's a range. I'm creating formulae, breaking down each piece w/left and mid functions (and of course days could be one or two chars so must allow for that). Just looking for a more elegant approach than mine
Unfortunately for what you are doing, I do not know of a more elegant solution. Even if you are just using one field, you can use the minimum and maximum functions to get the start and end dates.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.