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

I have this scenarios

The date is transmitted in this format

At the Google Sheets stage, I created the following parser:

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?


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



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

Sorry, how i can do this?


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:


Awesome that you figured it all out :slight_smile:

1 Like