# Format issue dates google sheets

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

1 Like

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?

1 Like

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)

here is what i get in google sheets

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

when i use your formula i get formula parsing error code

1 Like

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?

Can you show the formula you used in the sheet?

This is correct. The block `seconds since 1970` gives this output with decimal places.

I just tried the first number using my formula and I can get the date

Using the formula `=G2/86400+DATE(1970,1,1)`

1 Like

Sorry, my mistake!

1 Like

here is what i do :

1 Like

I can confirm that @muneer’s formula works. So maybe your A2 cell is not formatted correctly. What is the cell format for A2

1 Like

Format your date column as a number only. It should work.

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

1 Like

You are setting your computer to European format which uses the comma instead of the decimal point.

1 Like