Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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;.........
After you create this variables you can use the long name expression for names:
for example:
=date(today(), 'DD/MMMM/YYYY') will return the date with the full month name.
The expression:
=date(today(),'WWWW DD/MMMM/YYYY') will return long day name, number of the day, long Month name and year
Regards,
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.
Regards,
If you are using a calender you can also add them as a field, fe:
JOIN (Calendar)
Load * Inline [
Month, MonthName
1, Januari
2, Februari
3, Maart
4, April
5, Mei
6, Juni
7, Juli
8, Augustus
9, September
10, Oktober
11, November
12, December];
After you create this variables you can use the long name expression for names:
for example:
=date(today(), 'DD/MMMM/YYYY') will return the date with the full month name.
The expression:
=date(today(),'WWWW DD/MMMM/YYYY') will return long day name, number of the day, long Month name and year
Regards,
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
Hi Erich,
This was exactly what I was after.
Thanks