[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]

Thanks for the answer. Please tell me. Is it better to do it in Tools or Google Sheet?

@WnW_Dental_Marketing You can do this in both, and you will get the same result

Hi @WnW_Dental_Marketing Both will work. However, It is better to do in Google sheet in case you want to save the operation. If you require additional assistance, please don’t hesitate to reach out to us. MSquare Support Visit us here Youtube Channel

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

@WnW_Dental_Marketing I am glad this problem is solved please Mark this as solved it will help others. we will try to solve your other problem. [Screenshot 2024-01-25 173618]

In case someone else needs this info in the future, this is how you mark the most helpful response as a solution :white_check_mark: [image] Awesome that you figured it all out :slight_smile:

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

Questions

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

Topic		Replies	Views
How to format/parse date Typeform - Google sheets Questions date-time-functions , google-sheets , typeform	3	437	December 21, 2023
Getting Google Sheets to recognize Date (from Gmail) as a Date Beginner Questions	1	385	April 27, 2022
Transform a date in text format to a date format Beginner Questions functions , mapping , google-sheets	5	1446	March 6, 2024
Compare date in Google sheet with today's date Questions date-time-functions	9	766	October 4, 2024
TimeZone values should be entered in HHMM format Questions google-sheets	3	258	February 29, 2024

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

Related topics