# Convert Date to 'Month name' and 'Week Number' **URL:** \ **Category:** Ask for Help\ **Created:** [May 30, 2023, 6:48am UTC](https://community.glideapps.com/t/convert-date-to-month-name-and-week-number/62273 "2023-05-30T06:48:04Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![PBOWER](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pbower/32/92725_2.png) [@PBOWER](https://community.glideapps.com/u/PBOWER)\ **Post date:** [May 30, 2023, 6:48am UTC](https://community.glideapps.com/t/convert-date-to-month-name-and-week-number/62273/1 "2023-05-30T06:48:04Z")
Hi, I’ve used the WEEKNUM function to get a week number from a date, so 22/3/2023 becomes week ‘12’. What I need though is this to write to two columns, ‘month’ and ‘week’. So this would instead write ‘March’ and ‘Week 4’. Can this be done? I also have the column that the date picker is writing to, set to ‘date only’. However, a second template column that is reading from this date also writes the time. Can I stop that? Also, can I change the format from 3/22/2023 to 22/03/2023? ---
**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:** [May 30, 2023, 7:22am UTC](https://community.glideapps.com/t/convert-date-to-month-name-and-week-number/62273/2 "2023-05-30T07:22:11Z")
> [@PBOWER](#): > > I also have the column that the date picker is writing to, set to ‘date only’. However, a second template column that is reading from this date also writes the time. Can I stop that? Are you sure that you’re using a Date picker, and not a DateTime picker? I would check that first. > [@PBOWER](#): > > I’ve used the WEEKNUM function to get a week number from a date, so 22/3/2023 becomes week ‘12’. What I need though is this to write to two columns, ‘month’ and ‘week’. So this would instead write ‘March’ and ‘Week 4’. Can this be done? A simple way to handle this is with the [Format Date](https://www.glideapps.com/plugins/format-date) plugin. However, be aware that has been known to give inconsistent results, especially if you have users in different regions with different regional date/time settings. Personally, when I need to get a month name from a date, I do it using the following steps: - Firstly, I create a column (anywhere) with a list of month names, starting from January, one row for each month. - Then I determine the month index number from the Date using a Math column with the following formula: `Month(Date)-1` - And finally, I use a Single Value column that targets my list of month names column, taking N from start where N is the month index. I have found the above to be the most reliable method. > [@PBOWER](#): > > Also, can I change the format from 3/22/2023 to 22/03/2023? Again, you can use the Format Date plugin for this, although it shouldn’t be necessary as all date formatting should usually respect the individual users device/browser regional settings. ---
**Author:** ![PBOWER](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pbower/32/92725_2.png) [@PBOWER](https://community.glideapps.com/u/PBOWER)\ **Post date:** [May 30, 2023, 8:20am UTC](https://community.glideapps.com/t/convert-date-to-month-name-and-week-number/62273/3 "2023-05-30T08:20:30Z")
Hi Darren, Thank you for your reply. I am definitely using only the date picker (see attached screenshot). However, the second template column that is copying the first column adds the time (although not the ‘real’ time, always midnight. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/f/4f00632105e8abd07b78cde03af873c05b5c93d4.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/8/68cb0417d778e940da46445c0dfb8026ee9c09b5.png) I’ll try the plugin to change the date format, and try your suggestion re; the week numbering. Thank you! ---
**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:** [May 30, 2023, 8:27am UTC](https://community.glideapps.com/t/convert-date-to-month-name-and-week-number/62273/4 "2023-05-30T08:27:42Z")
> [@PBOWER](#): > > However, the second template column that is copying the first column adds the time (although not the ‘real’ time, always midnight. Okay, try using a Math column instead of a template. ---
**Author:** ![PBOWER](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pbower/32/92725_2.png) [@PBOWER](https://community.glideapps.com/u/PBOWER)\ **Post date:** [May 30, 2023, 8:34am UTC](https://community.glideapps.com/t/convert-date-to-month-name-and-week-number/62273/5 "2023-05-30T08:34:22Z")
What would you suggest to put in the ‘Configuration’ and ‘replacements’? ---
**Author:** ![PBOWER](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pbower/32/92725_2.png) [@PBOWER](https://community.glideapps.com/u/PBOWER)\ **Post date:** [May 30, 2023, 8:36am UTC](https://community.glideapps.com/t/convert-date-to-month-name-and-week-number/62273/6 "2023-05-30T08:36:25Z")
Yes, that works!! Thank you ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/d/5d8a5230aad82f1b6d4d4fbcdce1cb5cc7c7d8e1.png) ---
**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:** [May 30, 2023, 8:40am UTC](https://community.glideapps.com/t/convert-date-to-month-name-and-week-number/62273/7 "2023-05-30T08:40:54Z")
Yeah, sorry I should have suggested that first. The nice thing about using a math column is that it’s still a valid date, and so it can be used in any subsequent date/time comparisons. When you use a template it gets converted to a string. Both are useful, depending on what you intend to do with the result. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 31, 2023, 8:41am UTC](https://community.glideapps.com/t/convert-date-to-month-name-and-week-number/62273/8 "2023-05-31T08:41:09Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.