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


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

2 Likes

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

2 Likes

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

3 Likes

@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

Sorry, how i can do this?

2 Likes

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:

1 Like