'date of last meeting booking in meeting tool' not showing date in google sheet

[DavidJKenton]

Hi,

I have created a workflow to populate a google sheet, which as below is populating the data as I have instructed.

However, the column 'Time Allocation' which is populated when a customer has booked a meeting using the meeting tool and it does work but the data doesnt appear as a date, its just a random number. I have tried formatting the column to date but that doesnt seem to work.

Can anyone let me know what I am doing wrong?

[DavidJKenton · Accepted solution]

All good sorted it. Realised the 13 digit number is a time stamp, used formula to amend to show the date correctly.

[MRaman]

What is the formula you used? I have the same issue.

[DavidJKenton]

Hi MRaman,

I used the below formula.

=CELL/86400000+DATE(1970,1,1)

Hope this works for you mate.

Cheers