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

[WnW_Dental_Marketing]

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

[Abhishek]

Hey @WnW_Dental_Marketing

Try this formula

The output

[WnW_Dental_Marketing]

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

[Abhishek]

@WnW_Dental_Marketing

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

[Msquare_Automation]

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

[WnW_Dental_Marketing]

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

[Abhishek]

@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.

[WnW_Dental_Marketing]

Sorry, how i can do this?

[Michaela]

In case someone else needs this info in the future, this is how you mark the most helpful response as a solution

Awesome that you figured it all out