I have a client that wants to show weeks like the following:
Jun 13 - 31
Jun 22 - 28
The field I am is using is called 'Createddate'. I have trying searching but cant seem to find anything. Any suggestions would be helpful.
You can use Dual with Mapping to get this kind of result:
Question about Mapping and Dual
makedate(2015) + RowNo() -1 as date
dual(date(WeekStart(date), 'MMM DD') & ' - ' & date(WeekEnd(date), 'DD'), WeekStart(date)) as NewWeek
DROP Table t;
Retrieving data ...