# 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:** 2
**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, 8:49pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/21 "2022-01-18T20:49:36Z")
Hi @tatiang, here is my project link: [https://x.thunkable.com/copy/17cbb4111bb99cf647296a195d7de431](https://x.thunkable.com/copy/17cbb4111bb99cf647296a195d7de431) 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, 9:48pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/22 "2022-01-18T21:48:25Z")
Whoa… that’s a lot of screens! What is the name of the screen that you’re having problems with? ---
**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, 9:57pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/23 "2022-01-18T21:57:51Z")
Hi @tatiang, it is my “FVAddNewScreen”. 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, 10:00pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/24 "2022-01-18T22:00:33Z")
I see it. I think it’s called “MANFVAddNew”. ---
**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, 10:01pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/25 "2022-01-18T22:01:17Z")
Yes, that is correct 👍 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, 10:02pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/26 "2022-01-18T22:02:31Z")
It’s referring to a data source that doesn’t exist, “MAN First Visits”: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/8/481a6b622a1b7f90d7a9f3ecd37f00bcfa987f92.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/a/fa9cee42ea91bafe54430025e783a679794f83ba.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, 10:03pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/27 "2022-01-18T22:03:13Z")
Which Data Source? ---
**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, 10:06pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/28 "2022-01-18T22:06:28Z")
“MAN First Visits”. Maybe that’s because I don’t have access to that Google Sheet. I’m going to try it with one of my own. ---
**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, 10:10pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/29 "2022-01-18T22:10:51Z")
Ok 👍 It is suppose to write data to MAN First Visits/FVENTRYFORM a row at a time but the “DATE” column is now always empty. I suspect, because the “DATE” field keeps disappearing before it can be written. 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, 10:13pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/30 "2022-01-18T22:13:13Z")
But the date label has no connection to the Google Sheet so I don’t think that’s the problem. Here’s a clue… when I add a vibrate block and test it on my iPhone, it doesn’t vibrate: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/2/120b84c42708135c825dd28bfc24862dfa57909b.png) But I remove the `set` and `update` blocks, it does vibrate. So something is not working either in the `Convert` function or in the `update value` block. ---
**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, 10:16pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/31 "2022-01-18T22:16:39Z")
Also, I think part of the problem is that you are updating a row value when the date is picked but creating a row when the save button is clicked. So first you update the row – but there is no row yet – and then you create the row. I think you should not update the value until _after_ the row has been created. And your create row block doesn’t have a spot for a date value… you have to make sure you have “DATE” as a column header in the Google Sheet before you add it to Thunkable. If you put it in after you added it, you need to re-sync your data source to your project. ---
**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, 10:17pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/32 "2022-01-18T22:17:06Z")
Have I set the blocks correctly in the “Create row” block? ---
**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, 10:18pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/33 "2022-01-18T22:18:25Z")
You’ll want to set it up like this: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/5/753605fdb56e96a6bd7f7ffb1c76f0c27fc7ad3c.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 18, 2022, 10:21pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/34 "2022-01-18T22:21:07Z")
When I use the `Convert Date` function and apply the result to a different label, the label **disappears**. This indicates an internal crash in the project. So there’s a problem with how you set up that function. And that’s part of why Google Sheets is blank. ---
**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, 10:23pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/35 "2022-01-18T22:23:41Z")
**Lots of problems here:** ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/0/20433403a5425d955708a18696c0d0e085ec79ca.png) Please look carefully at my example and compare it to yours. Some things I notice: you use `app variable month` twice but the second `set` block should be for the year. You are setting the `stored variable email` when it should be `app variable date2 as DDMMMYYY`. You are therefore returning a variable with a blank value because the function is not set up right. My advice is this: before getting too complicated, make sure something _simple_ works. Can you set a label to the result of the function and see the value you expect? That should be step 1 before you worry about Google Sheets or anything else. ---
**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, 10:26pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/36 "2022-01-18T22:26:19Z")
I am going to change my blocks in the “AddRecBtnSave” blocks as per your suggestion. The name of the Column in my Google Sheets is “DATE”. What should I do with regards to the “Convert Date” function? ---
**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, 10:37pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/37 "2022-01-18T22:37:11Z")
Hi @tatiang, I have change the “Save” blocks as suggested. See below: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/d/1ded8cf61cd1771dfd04c58bbdb74d694ceea2e5.png) and the Label stills disappears. 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 18, 2022, 10:42pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/38 "2022-01-18T22:42:57Z")
Hi @tatiang, I am rectifying the errors in the Convert Date function. I noticed you have suggested using "app variable date2 and not app variable date. Why is this? > [@tatiang](#): > > You are setting the `stored variable email` when it should be `app variable date2 as DDMMMYYY`. ---
**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, 10:54pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/39 "2022-01-18T22:54:37Z")
I’m talking about this variable: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/0/80e1fc32f11d61c2b668647f90cc1af27f99647b.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, 11:04pm UTC](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039/40 "2022-01-18T23:04:45Z")
Hi @tatiang, it now works beautifully! The errors “ **were** ” in my **Convert Date function**. I have used “ **app variable date** ” and “ **not app variable date2** ” because app variable date2 was created for the copy of my app. **Well done sir!** I do have a couple more questions to ask on this topic… 1. On my app’s “ **MANFVAddNew** ” screen, I have just set my " **DatePickerInputRow’s" visiblity to “false”** because I only want the **Date Picker** to appear when the user clicks the **Date Label (AddRecLabelBox)**. After he has entered his date, I wish for the “ **DatePickerInputRow** ” to disappear again. How would I do that? As you can see below, I have already created the blocks to make the " **DatePickerInputRow** ’’ appears but how would I make it disappear after the user has selected a date? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/f/ef9dbc631065cce29634a81ba45e247b9736bd54.png) I forgot to add the other images… Before the user clicks on the Date entry box ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/3/d3c6ce41c91ce9e5aad1804ab33aa26d977ac9ab.png) When the users clicks the Date entry box the Date Picker Row appears ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/8/98ba1ff6a732312d2b31109e9f0ad0d620650dca.png) The user selects a date ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/2/c2900d6f27e80f7ecd5bf61d1c04bff4ef53d04d.png) After the **Date** is selected the **Date Picker row** is still **visible**. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/c/5c27c881325e3fd776d2b20c9b104dfed358241a.png) Andos. [Previous page](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039.md?page=1) [Next page](https://community.thunkable.com/t/is-there-a-way-to-create-your-own-date-format/1673039.md?page=3)