How can I choose to display full/long month names or week names instead of the shorter version?I have added the following:
code][SET MonthNames='jan;feb;.......SET LongMonthNames='January;February;.....SET DayNames='mo;tu;...........SET LongDayNames='Monday;Tuesday;.........
Well if you want to display it instead, why are you adding a 2nd variable? Just replace the MonthNames system variable values with January, etc.
If you are using a calender you can also add them as a field, fe:
JOIN (Calendar)Load * Inline [Month, MonthName1, Januari2, Februari 3, Maart4, April 5, Mei6, Juni7, Juli8, Augustus9, September10, Oktober11, November12, December];
After you create this variables you can use the long name expression for names:
=date(today(), 'DD/MMMM/YYYY') will return the date with the full month name.
=date(today(),'WWWW DD/MMMM/YYYY') will return long day name, number of the day, long Month name and year
Or just change it into:
[SET MonthNames='January;February;.....SET DayNames='Monday;Tuesday;.........
That should also work I think, if you don't need the short names
This was exactly what I was after.
Retrieving data ...