# Month(december) = "" **URL:** \ **Category:** Report a Bug\ **Created:** [December 1, 2020, 6:58pm UTC](https://community.glideapps.com/t/month-december/19241 "2020-12-01T18:58:04Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Xavier\_Delplanque](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xavier_delplanque/32/45565_2.png) [@Xavier\_Delplanque](https://community.glideapps.com/u/Xavier_Delplanque)\ **Post date:** [December 1, 2020, 6:58pm UTC](https://community.glideapps.com/t/month-december/19241/1 "2020-12-01T18:58:04Z")
Hi all, It looks like mont(december) doesn’t return any value. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d793e8c52dd8edc16aad7f8e40de5d38e2354fa6.png) Is that a bug or am I missing something? Thanks! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 1, 2020, 10:17pm UTC](https://community.glideapps.com/t/month-december/19241/2 "2020-12-01T22:17:24Z")
Strange. Is that date Glide formatted or are you using your own format? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 2, 2020, 6:56am UTC](https://community.glideapps.com/t/month-december/19241/3 "2020-12-02T06:56:48Z")
I notice that the string ‘dec’ is using an extended ASCII character (`é`). Perhaps that is tripping Glide up. Try replacing that with a standard ASCII ‘e’, and see if that helps. ---
**Author:** ![Xavier\_Delplanque](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xavier_delplanque/32/45565_2.png) [@Xavier\_Delplanque](https://community.glideapps.com/u/Xavier_Delplanque)\ **Post date:** [December 2, 2020, 9:11am UTC](https://community.glideapps.com/t/month-december/19241/4 "2020-12-02T09:11:41Z")
> Strange. Is that date Glide formatted or are you using your own format? @ThinhDinh Yes, the date comes from Glide. However the spreadsheet is configured in french (so I can use €) which may change the way Glide records the dates. > Try replacing that with a standard ASCII ‘e’, and see if that helps. @Darren_Murphy Thanks, will try. I believe I’ll need to change the spreadsheet local then, otherwise the character will change again. Not a great workaround since It will also change my default monetary unit to $. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 2, 2020, 9:22am UTC](https://community.glideapps.com/t/month-december/19241/5 "2020-12-02T09:22:32Z")
As long as your column is a numeric column, you can always assign the unit (Euros) in the glide data editor, instead of doing it in the sheet. ---
**Author:** ![Xavier\_Delplanque](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xavier_delplanque/32/45565_2.png) [@Xavier\_Delplanque](https://community.glideapps.com/u/Xavier_Delplanque)\ **Post date:** [December 2, 2020, 9:36am UTC](https://community.glideapps.com/t/month-december/19241/6 "2020-12-02T09:36:27Z")
I changed the local and it works now. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/1/718d46f8fa9b393e24be32d51fa9a9d5b5636436.png) It still looks like a bug to me, since the documentation doesn’t mention to use the US format. Sounds like some ASCII character are messing up the parsing. Thanks for your help. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 2, 2020, 9:45am UTC](https://community.glideapps.com/t/month-december/19241/7 "2020-12-02T09:45:22Z")
> [@Xavier\_Delplanque](#): > > Thanks, will try. I believe I’ll need to change the spreadsheet local then, otherwise the character will change again. Not a great workaround since It will also change my default monetary unit to $. If you don’t want to change your sheet locale setting, what you could do is insert a column in your sheet (say “Clean Date”), and then use a formula to replace the accent. Something like this: `=REGEXREPLACE(L2,"déc","dec")` (that assumes that December is the only month affected, and you’d probably need to make it an array formula) Then in the data editor, you could use an if-then-else column to determine whether to use the raw date or the “clean” date in your math calculation… ![Screen Shot 2020-12-02 at 5.42.59 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20af0c2a272b317e255035c52bd9b6b70a58f6ca.png) There is probably a much more elegant way to do it, but that’s one way that could work. Edit: Actually, I just did a little more testing and I suspect that REGEX replacement might not work in your case, because REGEXREPLACE expects strings, and your dates may be stored in the GSheet as numbers. But let me know if you want to pursue this option, and I’ll see if I can come up with a more robust formula. Edit 2: This might work: `=ARRAYFORMULA(IF(REGEXMATCH(TO_TEXT(L2:L),"déc"),REGEXREPLACE(TO_TEXT(L2:L),"déc","dec"),L2:L))` ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 2, 2020, 10:44am UTC](https://community.glideapps.com/t/month-december/19241/8 "2020-12-02T10:44:07Z")
Does a template column work in this case? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 2, 2020, 11:07am UTC](https://community.glideapps.com/t/month-december/19241/9 "2020-12-02T11:07:21Z")
Actually, yes! But I think you need two template columns: ![Screen Shot 2020-12-02 at 7.03.50 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce87b5011b0edd13ca29a83f9bb0a454902372b0.png) TPDec: just populates each row with ‘dec’ TPDate: substitutes déc with TPDec (dec) And then Month uses TPDate in the math calculation. I knew there would be a much simpler method 😂 @Xavier_Delplanque ---
**Author:** ![Xavier\_Delplanque](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xavier_delplanque/32/45565_2.png) [@Xavier\_Delplanque](https://community.glideapps.com/u/Xavier_Delplanque)\ **Post date:** [December 2, 2020, 2:33pm UTC](https://community.glideapps.com/t/month-december/19241/10 "2020-12-02T14:33:50Z")
Thanks for the research guys! I’ll have a look at templates. I haven’t tried it yet. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 2, 2020, 3:17pm UTC](https://community.glideapps.com/t/month-december/19241/11 "2020-12-02T15:17:14Z")
No problem. I think that template solution is the simplest and best. And it’s easily extendable. For example, if you had another case, maybe “fèb”, then all you would need to do is add a TPFeb column and then include that as a second substitution in the TPDate template column. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 2, 2020, 3:23pm UTC](https://community.glideapps.com/t/month-december/19241/12 "2020-12-02T15:23:03Z")
It would be much easier and cleaner if we can replace by a custom value though. It always annoys me to have to create more columns to do this. 😴 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 2, 2020, 3:33pm UTC](https://community.glideapps.com/t/month-december/19241/13 "2020-12-02T15:33:41Z")
Being able to use regular expressions in templates would be _awesome_ 😆