- Data field in Google Sheet
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/3901354e-1783-4d5d-ab4b-6bc7a9670150.png)
- Zap configured to pic the date and time - Looks like it reads correctly!
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/46bc8870-6a31-4e33-b409-b811a1f2d681.jpg)
- Wrong Date and time computed by the Zap: When tested, event is indeed created for 2027 July!
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/5b5f3c4b-f2fd-4368-ba18-4839689e5d39.jpg)
Not convinced why any sort of transformation is needed for such a simple usecase when the data is available in simple and direct format.