"The specific time range is empty - FROM UNIX Format

Hi ​@ianrusselgabod 

For us to have more info, post these screenshots:

• For Zap step 3, showing the From Timezone
  • Should be set to: UTC
• How Zap step 5, is configured in EDIT mode

This is Zap 3 and the 2nd pic is Zap 5

​@Troy Tessalone 

​@Troy Tessalone above are the configurations I did, but i dont why its not working, i mean after i click published, then a few minutes later, it will send out notifications that there’s a problem in my Zap

​@ianrusselgabod 

You may need to add a Filter step to check that the input values for the Formatter steps exists from the previous Zap steps: https://zapier.com/apps/filter/help

To troubleshoot, check your Zap Runs history details to see the DATA IN/OUT for each step: https://zapier.com/app/history/

Sorry, I’m confused, what step should i add the filter? Here’s the error ​@Troy Tessalone 

​@ianrusselgabod 

In the Zap Run View in the Zap Editor, click on a Zap step.

There will be a window on the right that shows the DATA IN/OUT tabs so you can see the actual data sent/returned.

You should add Filter step as early as possible in the Zap to check the data points exist for the data points that are used in the Formatter steps.

Filter help: https://zapier.com/apps/filter/help

Also, did i do this righ? the format should be From UNIX to YYYY-MM-DDTHH:mm:ssZ

​@Troy Tessalone I tried to re configure it but it still didnt work, i want the time from UNIX to this format EST YYYY-MM-DDTHH:mm:ss-05:00

This is my date started BUT

when I do the date ended, it still has the same time, now im more confused. 
 

​@ianrusselgabod 

Post screenshots from a Zap Run that had an error that show the DATA IN/OUT for each Zap step.

https://zapier.com/app/history/

See screenshot for where to find the tabs: DATA IN/OUT

​@ianrusselgabod 

Regarding the Filter, add the Filter as Zap step 2.

Filter help: https://zapier.com/apps/filter/help

The Filter Zap step should have 2 conditions.

• Date Start exists
  • Variable from Zap step 1
• Date End exists
  • Variable from Zap step 1

If these values do not have values in the DATA OUT from Zap step 1, then the 2 Formatter steps will not do anything, and thus why the GCal step will result in an error.

​@Troy Tessalone I’m confused but here’s what I did. I add filter on the 2nd step and these are the configurations I made, whats next? 

​@ianrusselgabod 

Test your Zap live again.

Check your Zap Runs history details to see the DATA IN/OUT for each step to help you trace the data flow and troubleshoot: https://zapier.com/app/history/

If you still need help, post screenshots from a Zap Run that had an error that show the DATA IN/OUT for each Zap step.

See screenshot below for where to find the tabs in a Zap step from a Zap Run: DATA IN/OUT

You can achieve the same thing with a code block. After you have established that the dates are there you can set up the code as in the block below. 

I use python in the configuration add your Date Start and Date End as input data. Here I have added it as text you can select the data from your webhook

 

Paste in this code into the code area. 
 

import datetime

start_date = int(input_data['start_date'])
end_date = int(input_data['end_date'])


def convert_to_eastern(timestamp):
    """
    Convert a UNIX timestamp to US Eastern Time in the format YYYY-MM-DDTHH:mm:ssZZ.

    Args:
        timestamp (int): UNIX timestamp in seconds.

    Returns:
        str: Formatted date string in US Eastern Time.
    """
    # Convert the UNIX timestamp to UTC datetime
    utc_time = datetime.datetime.fromtimestamp(timestamp, datetime.timezone.utc)

    # Define US Eastern Time offset (Standard Time: UTC-5 hours)
    eastern_offset = datetime.timedelta(hours=-5)
    eastern_timezone = datetime.timezone(eastern_offset)

    # Convert UTC time to US Eastern Time
    eastern_time = utc_time.astimezone(eastern_timezone)

    # Format the datetime into the desired string format
    formatted_time = eastern_time.strftime("%Y-%m-%dT%H:%M:%S%z")

    return formatted_time


est_start_date = convert_to_eastern(start_date)
est_end_date = convert_to_eastern(end_date)

output = [{
    'Start Date': est_start_date,
    'End Date': est_end_date,
    }]

You’ll then get two objects that you can place into where needed. 

 

It’s a different approach, but I hope it’s useful.

Hi ​@ianrusselgabod,

I just came across your post here and wanted to check in here to see how you’re getting on. Were you able to follow ​@Badger suggestion here?

Please do let us know if you’re still in need of some help on this at all - happy to assist further! 🙂