# What am I doing wrong with the text to date glide plugin? **URL:** \ **Category:** Ask for Help\ **Created:** [November 11, 2021, 1:18pm UTC](https://community.glideapps.com/t/what-am-i-doing-wrong-with-the-text-to-date-glide-plugin/34394 "2021-11-11T13:18:13Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [November 11, 2021, 1:18pm UTC](https://community.glideapps.com/t/what-am-i-doing-wrong-with-the-text-to-date-glide-plugin/34394/1 "2021-11-11T13:18:13Z")
Hi, I have a Single Value column that contains the last date from a list of dates. I’m converting this using Text to Date plugin. However this doesn’t seem to work correctly. ![Screenshot 2021-11-11 at 6.45.05 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/396e9c538759892f8d56185e6b9104f2c5dfbf89.png) ![Screenshot 2021-11-11 at 6.42.52 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/afdcfbb9393c03c27f81cd0543b5c5f99d963b4d.png) It’s not giving me the right date. How do I set the right locale? Regards, Ruchika ---
**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:** [November 11, 2021, 1:27pm UTC](https://community.glideapps.com/t/what-am-i-doing-wrong-with-the-text-to-date-glide-plugin/34394/2 "2021-11-11T13:27:21Z")
I encountered a similar issue with the Format Date plugin a couple of days ago: > > > \Screen Shot 2021-11-09 at 6 21 12 PM > > Locale is set as English (AU), but it appears to be interpreted as en-us, so instead of returning 9th November, it returns 11th September. Which date format is used in your location? (dd/mm/yyyy or mm/dd/yyyy) ---
**Author:** ![Mozza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozza/32/34362_2.png) [@Mozza](https://community.glideapps.com/u/Mozza)\ **Post date:** [November 11, 2021, 1:47pm UTC](https://community.glideapps.com/t/what-am-i-doing-wrong-with-the-text-to-date-glide-plugin/34394/3 "2021-11-11T13:47:29Z")
Hi, I might be wrong, but I think that you need FormatDate calculated column and not TextToDate. Then you can use Luxon to format it as you like. For example, dd.MM.yyyy. will be 01.11.2021. (1st of November). ---
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [November 12, 2021, 10:10am UTC](https://community.glideapps.com/t/what-am-i-doing-wrong-with-the-text-to-date-glide-plugin/34394/4 "2021-11-12T10:10:03Z")
@Darren_Murphy Yes. It doesn’t see to recognise the locale. Do you know the syntax of how to update the Locale in the Text To Date configuration? My locale uses the dd/mm/yyyy format. ---
**Author:** ![RuchikaAbbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchikaabbi/32/11240_2.png) [@RuchikaAbbi](https://community.glideapps.com/u/RuchikaAbbi)\ **Post date:** [November 12, 2021, 10:10am UTC](https://community.glideapps.com/t/what-am-i-doing-wrong-with-the-text-to-date-glide-plugin/34394/5 "2021-11-12T10:10:59Z")
@Mozza I did try that but it the resulting column doesn’t seem to work correctly in Date math. ![Screenshot 2021-11-12 at 3.37.47 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b8841a3d85669f0a4cccb30adfb1c3ee93034f98.png) I tried adding +30 days to it ---
**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:** [November 12, 2021, 10:14am UTC](https://community.glideapps.com/t/what-am-i-doing-wrong-with-the-text-to-date-glide-plugin/34394/6 "2021-11-12T10:14:03Z")
I think it’s a bug. I’ve reported it as an issue. ---
**Author:** ![Mozza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozza/32/34362_2.png) [@Mozza](https://community.glideapps.com/u/Mozza)\ **Post date:** [November 12, 2021, 10:28am UTC](https://community.glideapps.com/t/what-am-i-doing-wrong-with-the-text-to-date-glide-plugin/34394/7 "2021-11-12T10:28:08Z")
I think that you should do your calculations with original date column and not with formated date. And then format the given result again. ---
**Author:** ![Mozza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozza/32/34362_2.png) [@Mozza](https://community.glideapps.com/u/Mozza)\ **Post date:** [November 12, 2021, 10:36am UTC](https://community.glideapps.com/t/what-am-i-doing-wrong-with-the-text-to-date-glide-plugin/34394/8 "2021-11-12T10:36:48Z")
I did it without any problems. ![dateCalc](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/cea5c91f1762f13882282edcda0819c2f15f0bb8.jpeg) ---
**Author:** ![Mozza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozza/32/34362_2.png) [@Mozza](https://community.glideapps.com/u/Mozza)\ **Post date:** [November 12, 2021, 10:40am UTC](https://community.glideapps.com/t/what-am-i-doing-wrong-with-the-text-to-date-glide-plugin/34394/9 "2021-11-12T10:40:40Z")
Sorry for the million replies… I could write this in one post. Essentially, you will need two date/time columns (one will be a reference date and the other will be with days added), and you will have to create two FormatDate columns to display those dates as you wish. Hope this will help.