# Is there a way to create your own date format? **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** design, beginner, help\ **Created:** [January 14, 2022, 5:51pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039 "2022-01-14T17:51:01Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [January 14, 2022, 5:51pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/1 "2022-01-14T17:51:01Z")
Hi, is there a way to create your own date format? I am trying to create the format, DDMMMYYYY (eg. 05FEB2021). This is the international ICAO date format for aviation. None of the available formats are remotely acceptable or eligible. I have tried to convert the format from one of the available formats in Thunkable in the hope that it could be used in my Google Sheet but this didn’t seem to work so I obviously cannot use the date picker either. See below: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/7/d727adc7dcfa4d326837adb68916b46a3249c222.png) Many thanks, Andos. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [January 14, 2022, 6:05pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/2 "2022-01-14T18:05:57Z")
Create a function to make it look like the format you want. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [January 15, 2022, 12:27am UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/3 "2022-01-15T00:27:20Z")
Hi @muneer, I cannot see how change date input format using a function because I think I am being restricted by the available formats somehow: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/4/d426fd554f95a420f4fd92e59ec34d7b14aac6f1.png) Please see my attempt in the blocks, I have tried various permutations to achieve this but I know something is wrong in my blocks but I cannot see or understand what it might be. My blocks: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/e/1ec04b8336dacea677f4767df2f3b7980bae356e.png) Ideally, I would like the **whole app** to use this date format. Thanks, Andos. ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [January 15, 2022, 12:55am UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/4 "2022-01-15T00:55:53Z")
Please make a feature request for this! It would be ideal to be able to dictate the exact formatting of the date displayed. There’s a lot of room for improvement when it comes to getting/setting/displaying/manipulating dates ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [January 15, 2022, 2:01pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/5 "2022-01-15T14:01:37Z")
Ok @jared, how do I make a “feature request”? Andos. ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [January 15, 2022, 2:10pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/6 "2022-01-15T14:10:39Z")
Yep! @andos-avlog Fill the filling form out and submit it [here](https://github.com/thunkable/thunkable-issues/issues) as a new “issue” | name | about | | --- | --- | | Feature request | description | **Is your feature request related to a problem? Please describe.** A clear and concise description of what the problem is. Ex. I’m always frustrated when […] **Describe the solution you’d like** A clear and concise description of what you want to happen. **Describe alternatives you’ve considered** A clear and concise description of any alternative solutions or features you’ve considered. **Additional context** Add any other context or screenshots about the feature request here. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 16, 2022, 5:56am UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/7 "2022-01-16T05:56:09Z")
Additional date formats would be great but… until then, you can use this conversion: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/8/78785cccb84cd0126e7e92fd9b75db72f36b9641.png) To try it out, see the screen with your username here: **Demo Project:** [Thunkable](https://x.thunkable.com/copy/5cb0d45c96a02dc3219e4cc6f0002677) The Date Input component needs to have this Style in the properties panel: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/f/1f7d356022e3ed9c259b4c83d2993bc1580fefe4.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/b/6b27f2e97d59507c045eb4611b6bca86448acf0b.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [January 16, 2022, 8:40am UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/8 "2022-01-16T08:40:58Z")
> [@tatiang](#): > > until then, you can use this conversion I did it this way thinking that the `Launch Picker` will actually show the calendar to pick the date but it didn’t. [https://x.thunkable.com/projectPage/61e3d0040817f000104d2331](https://x.thunkable.com/projectPage/61e3d0040817f000104d2331) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/0/60096db8b14d9ab9c768f3f0cb5b85a7efec0e1c.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 16, 2022, 9:05am UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/9 "2022-01-16T09:05:16Z")
Yeah, the Launch Picker doesn’t seem to work very well. And there’s no documentation about it: > **[Date Input](https://docs.thunkable.com/date-input#launch-picker)** ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [January 16, 2022, 6:56pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/10 "2022-01-16T18:56:44Z")
Thanks @tatiang and @muneer, I shall try this and I shall let you know how I get on. Many thanks, Andos. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [January 17, 2022, 10:53am UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/11 "2022-01-17T10:53:56Z")
Hi @tatiang, I have tried your suggestion and it works beautifully. See below: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/c/8c0e94fc044ef0a0fd8c52d6b5d84ec5c8f0b9de.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/5/5501534b88d61b385300af5698e24273aa537587.png) However, is it possible for this to be placed in a text input field for entry into a **Source Data Google Sheet** in the “ **DDMMMYYY** ” format as in my **Date Value** field? See below: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/b/fbb0aeb499464716a3328acf0e7d6b38f555e30b.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/0/b0cd5dea36ba73a142ab7717aa50ca7f24c1c055.png) So that when the date field is clicked on the Date Picker appears and when the user selects a date it will appear in the text/date field so that when it is saved, it will be to the Google Sheet in the DDMMMYYYY format. Or, am I overthinking it? Thanks, Andos. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [January 17, 2022, 1:11pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/12 "2022-01-17T13:11:35Z")
Hi @tatiang and @muneer, I have tried tatiang’s suggestion it worked great on my test sheet (see previous post) but now I have tried to integrate it into my project My project link: [https://x.thunkable.com/copy/430c64a7fd067b9d0cd04acba2650d43](https://x.thunkable.com/copy/430c64a7fd067b9d0cd04acba2650d43) And by doing so I end up with the following entry into my Google Sheet (row 1698) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/0/e038aac3116bdde7a33c3ec0059a00eeb48ddf09.png) As you can see it has entered “ **DDMMMYYYY** ” into the date column instead of the date I selected which was “ **17JAN2022** ”. How can I remedy this? Here are my blocks: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/c/1c476e4c9ef2ef2ca15bb0a96b7df8f45e18db3c.png) What block do I need to put in the “Date value” socket in my “ **create row** ” function to produce the correct format to be saved into my **Google Sheet**? I thought using the “ **call Data Input2"/ Get Date** ” block would be the solution but clearly it isn’t. I am a bit lost now. Many thanks, Andos. ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [January 17, 2022, 2:00pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/13 "2022-01-17T14:00:12Z")
Hey @andos-avlog Would you want to plug the return of the function you created into the createRow block? ![Screen Shot 2022-01-17 at 8.59.01 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/e/5e6db58ee253692574425b1bac5ebfe5d9b373e4.jpeg) ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [January 17, 2022, 2:03pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/14 "2022-01-17T14:03:25Z")
Hi @jared, yes I think that is what I am after. I am trying use the **date picker** to insert **my selected date** into the “ **Date value** ” in the “ **Create row** ” block. But the **DATE format** returned **must** be the “ **DDMMMYYYY** ” format (ie **05FEB2022** ). Thanks, Andos. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [January 17, 2022, 3:23pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/15 "2022-01-17T15:23:18Z")
Hi @jared, I just tried plugging the “ **Convert Date to DDMMMYYYY** ” function into the “ **DATE value** ” in my “ **Create row** ” block (see below): ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/7/a7b17b510108269db83ed3f9d62588d2a3e469f3.png) I then created a **dummy new record** (shown below): ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/0/f084b3a31a877a5626f32aa8b7486bdc1aeb22d6.png) The reconverted **back to original format** after entry (see below): ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/8/c8e8a701ceb3c323faad0f436b10b7e396f41cde.png) After saving entry via the app ( image below): ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/c/cc783bcb6829782913fcf2fd733f5da61d1d3498.png) There was no produced in my **Google Sheet (row 1699)**: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/3/836705f28e8b379054d51ce30e28027d74f93708.png) Could you please tell where I’m going wrong? Thanks, Andos. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [January 17, 2022, 5:11pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/16 "2022-01-17T17:11:55Z")
Hi @tatiang and @muneer, with regards to my date format issue, I was wondering if it was possible to save the value of the Date Label to a Google Sheet? As the way that you have shown me is how to display the date in correct format ( **DDMMMYYY** ) to display on a label, I was wondering if could enter that **label’s value as text** into my Google Sheet. I might sound daft but I was wondering if I use that concept as a solution maybe? Many thanks, Andos. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 17, 2022, 7:09pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/17 "2022-01-17T19:09:06Z")
You can use the value created by the function in ANY data source including a Google Sheet. After the date input is converted, it’s just a text string. It can be used just like any other text string or variable value. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 17, 2022, 7:16pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/18 "2022-01-17T19:16:51Z")
I’ve updated the demo. You would use these blocks to add the result to a Google Sheet: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/4/f442cb8e3b2bf1e99a9280b5852693ec57e90f0a.png) Demo project: [Thunkable](https://x.thunkable.com/copy/e3e45cdee9b72858698a555b80a222f5) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/e/de7e46d46177234d705e01da6557f3905cd9bf9d.png) ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [January 18, 2022, 1:35pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/19 "2022-01-18T13:35:58Z")
Hi @tatiang, I have applied the amended blocks to my sheet and exchanged my **“Date Input” box** for a Label ( **AddRecLabelBox** ) instead. When the **Label** is clicked it launches the “Date Picker” See blocks below: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/4/4457dd07b107b76166257ab1e43076491cc5b109.png) Curiously though, when I select a date from the date picker, my Label that the formatted date is suppose to appear on disappears altogether. At first, I thought it was perhaps that I had set the **Label’s visibility to “false”** but this was not the case. So I tried to resolve this by using a “ **wait for\_ seconds** ” block set to 20 seconds, but the **formatted Label** still disappeared the moment the date was selected. See 2 images below: Before date selected: The **Date Row** and **Formatted date Label** are still visible. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/2/f2d92c285b28fd8b28388664f3929abe24bd10ce.png) After the date is selected (in this case **18JAN2022** ) The **formatted date Label** vanishes. See below: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/f/7f1c287efd6329617d4d13ed4c03e9884074e9c0.png) Because the **formatted Label** has vanished, there is **no Date Entry made** into my **Google Sheet**. As you can see, I have tried this several times and always received the same result. See below: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/1/d19cd41de0766bbba4637421753e71c19d9eb405.png) Do you know why the **formatted Label** would keep disappearing like that? I can’t see anything mistakes (- in my novice opinion) of my blocks that I copied from you being wrong. In the **Design** area, the **formatted Label is set to “Visible”**. How can I fix this issue? Many thanks, Andos. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 18, 2022, 3:58pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/20 "2022-01-18T15:58:38Z")
You can share the project link with me if you like. I won’t be able to troubleshoot the Google Sheets issue completely without access to your Google Sheet but I can try it with my own and also take a look at the blocks to see why that might be happening and also why the label is disappearing. Labels don’t tend to disappear unless you’ve told them to. [Next page](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039.md?page=2)