Display formats?
So, I have a few oddities but donโt really know and canโt find a solution for these.
Year(Today()) returns 2,018 โฆ
rather than 2018 Month(Today()) returns 1 โฆ and I canโt find any way to make it January.
Is there some Format(string, format) style function that I can use that I seem to be missing?
Are these separate columns? Your Year one is probably a number type, so if you make ShowThousandsSeparator = false in the definitions, that should fix it. For the Month, maybe try making it a Date or DateTime type, but Iโm not sure that will help. Otherwise, you can convert it if you have to with IF functions. There is probably a simpler answer that someone can offer.
@Chris_Hutton For the Months display here is my work aroundโฆ https://plus.google.com/+DavidHopkins4355398/posts/5d2JoeDhBpw
Im going to look for the ShowthousandsSeparator setting nowโฆ Thanks for the response.
@David_Hopkins for the Yearโฆ here is the line that Iโm using in the template:
Payments by Student in <<Year(Today())-1>>
and it displays as:
Payments by Student in 2,017
Iโm not sure where Iโd set ShowThousandsSeparator for that, since itโs a system function, and not actually from a field.
For year try:
CONCATENATE(Year(Today()))
You will need to translate the month number into a month name. Try:
SWITCH(MONTH(TODAY()), 1, โJanโ, 2, โFebโ, 3, โMarโ, 4, โAprโ, 5, โMayโ, 6, โJunโ, 7, โJulโ, 8, โAugโ, 9, โSeptโ, 10, โOctโ, 11, โNovโ, โDecโ)
@Philip_Garrett_Appsh On Point again Philip!
Thank Youโฆ
the concat did the trickโฆ and I like the switch function tooโฆ iโll be using that a lot.
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |