# Format issue dates google sheets **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [October 30, 2021, 2:34am UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577 "2021-10-30T02:34:29Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![bibbi](https://avatars.discourse-cdn.com/v4/letter/b/db5fbb/32.png) [@bibbi](https://community.thunkable.com/u/bibbi)\ **Post date:** [October 30, 2021, 2:34am UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/1 "2021-10-30T02:34:29Z")
hi I use the block seconds since 1970 to record the dates or times of different events in a google sheets arrived in the spreadsheet I can not format these different information and I don’t see what’s blocking ---
**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:** [October 30, 2021, 3:04am UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/2 "2021-10-30T03:04:33Z")
It sounds like you are updating cells in Google Sheets with the value from the `seconds since 1970` block. Please post a screenshot of what a cell with the date value looks like in Google Sheets. And also the blocks you’re using in Thunkable (if you’re having trouble updating a cell). How are you trying to format the value in Google Sheets or Thunkable? And what do you want it to look like when it works? ---
**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:** [October 30, 2021, 3:31am UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/3 "2021-10-30T03:31:48Z")
If you are storing the date in Google sheet using the block `seconds since 1970` then you can use my solution in this post to turn it to normal date (note the last part of adding 5:30 hours is to adjust it for Indian local time) > [@Open Weather Map Sunrise/Set Parsing](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/12): > > This one is easy because Thunkable is using seconds since 1970 and what I do is connect a Google sheet as my data source and this sheet has two columns Unix-time and normal-time In the column normal time I have a formula =A2/86400+DATE(1970,1,1)+TIME(5,30,0) Then in Thunkable I update cell A2 and read cell B2 which has my answer. I use it to compute number of dates between two dates and other date functions. ---
**Author:** ![bibbi](https://avatars.discourse-cdn.com/v4/letter/b/db5fbb/32.png) [@bibbi](https://community.thunkable.com/u/bibbi)\ **Post date:** [October 30, 2021, 4:10am UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/4 "2021-10-30T04:10:34Z")
here is what i get in google sheets ![Capture d’écran 2021-10-30 à 06.05.53](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/5/c5f1a7d4532b6f33585ac5b429bae93f4d8de7ff.png) i format data in google sheets in the date column I would like to get the dates and in the hours column see only the hours ---
**Author:** ![bibbi](https://avatars.discourse-cdn.com/v4/letter/b/db5fbb/32.png) [@bibbi](https://community.thunkable.com/u/bibbi)\ **Post date:** [October 30, 2021, 4:17am UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/5 "2021-10-30T04:17:16Z")
when i use your formula i get formula parsing error code ---
**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:** [October 30, 2021, 4:22am UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/6 "2021-10-30T04:22:28Z")
You shouldn’t be getting decimal values. The number of seconds that have elapsed is always going to be an integer. What blocks are you using to update those cells? ---
**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:** [October 30, 2021, 6:51am UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/7 "2021-10-30T06:51:46Z")
> [@bibbi](#): > > i get formula parsing error code Can you show the formula you used in the sheet? > [@tatiang](#): > > You shouldn’t be getting decimal values This is correct. The block `seconds since 1970` gives this output with decimal places. ---
**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:** [October 30, 2021, 12:39pm UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/8 "2021-10-30T12:39:41Z")
I just tried the first number using my formula and I can get the date ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/8/08576fb472bc5ac6d2fc72d452a113d29fe2b8da.png) Using the formula `=G2/86400+DATE(1970,1,1)` ---
**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:** [October 30, 2021, 2:28pm UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/9 "2021-10-30T14:28:54Z")
> [@muneer](#): > > This is correct. The block `seconds since 1970` gives this output with decimal places. Sorry, my mistake! ---
**Author:** ![bibbi](https://avatars.discourse-cdn.com/v4/letter/b/db5fbb/32.png) [@bibbi](https://community.thunkable.com/u/bibbi)\ **Post date:** [October 30, 2021, 4:52pm UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/10 "2021-10-30T16:52:54Z")
here is what i do : ![Capture d’écran 2021-10-30 à 18.48.00](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/5/352a1b5b471368ae83353294dc248a00a6a03649.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:** [October 30, 2021, 4:55pm UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/11 "2021-10-30T16:55:44Z")
I can confirm that @muneer’s formula works. So maybe your A2 cell is not formatted correctly. What is the cell format for A2 ---
**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:** [October 30, 2021, 4:57pm UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/12 "2021-10-30T16:57:48Z")
Format your date column as a number only. It should work. ---
**Author:** ![bibbi](https://avatars.discourse-cdn.com/v4/letter/b/db5fbb/32.png) [@bibbi](https://community.thunkable.com/u/bibbi)\ **Post date:** [October 30, 2021, 5:28pm UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/14 "2021-10-30T17:28:31Z")
for me your formula must be written like this : =A2/86400+DATE(1970;1;1) to work and data like this : 1635081029,95 I don’t understand why the formatting commands built into google sheet don’t work I should probably determine the dates in thunkable and calculate the differences between the times also in thunkable ---
**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:** [October 30, 2021, 5:45pm UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/15 "2021-10-30T17:45:33Z")
You are setting your computer to European format which uses the comma instead of the decimal point. ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:14pm UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/16 "2024-11-08T13:14:34Z")