[image] I have this scenarios The date is transmitted in this format [image] At the Google Sheets stage, I created the following parser: [image] However, the date is not transferred to the Google Sheets cell. What am I doing wrong and at what stage should I make this correction. Thank you

Hey @WnW_Dental_Marketing Try this formula [Screenshot 2024-01-25 163352] [Screenshot 2024-01-25 165241] The output [Screenshot 2024-01-25 163408]

How to set time from Unix format to DD.MM.YYYY format

WnW_Dental_Marketing January 26, 2024, 1:36pm 7

Thanks guys. Problem solved. Everything works very well. Now the next problem has arisen Several filters. How to set it up correctly

3 Likes

Topic		Replies	Views
Parsed Dates Still Passing to Google Sheets as Timestamps How To date-time-functions , google-sheets	3	327	September 22, 2023
Getting Google Sheets to recognize Date (from Gmail) as a Date Getting Started	2	336	September 7, 2023
Format Date always Returning 1/20/1970 How To google-sheets	2	874	January 30, 2024
Parse Google Sheets Serial Number How To google-sheets	2	65	October 3, 2024
How to convert Unix Time to Normal How To date-time-functions , clickup	5	1810	May 26, 2024