Ensure Pacific Time Zone for Table Filtering in Clay App

Hi Clay S. Good day to you guys! Just wanted to ask if there is a way to make sure sure that we're using Pacific Time as timezone in our table? We wanted to make sure to filter the table based on created_at. Thank you! ❤️

7 comments

Clay
APP
·
·
Yes, you can set Pacific Time as your timezone when working with dates in Clay. Use the Format Date/Time formatter to convert your created_at dates to Pacific Time. Here's how: 1. Add the Format Date/Time formatter to your table 2. Select your created_at column as the input date 3. In the New Timezone field, specify Pacific Time (e.g., "America/Los_Angeles" or "PST") 4. Choose your desired output format Once formatted with Pacific Time, you can then filter your table using the created_at column with the correct timezone applied.
Sources: Clay formatters overview | Documentation | Clay University Format Date/Time with Clay Formatters Customize your table view | Documentation | Clay University
Abdul S.
·
·
Hey Christopher O. good question if you're working with created_at filters, you can try adjusting the time zone using the Format Date or Convert Timezone step in Clay set it to Pacific Time (PST/PDT), and then use that formatted date for filtering lmk if you need help setting that up!
Clay
APP
·
·
Perfect! You're on the right track. Use the Format Date/Time formatter to convert your created_at column to Pacific Time: 1. Add the Format Date/Time formatter to your table 2. Select your created_at column as input 3. In "New Timezone" field, enter "America/Los_Angeles" for Pacific Time 4. Choose your desired output format Once formatted with Pacific Time, you can filter your table using that converted date column. For filtering, click the filters button at the top of your table, add a filter, select your formatted date column, choose your comparison operator (equal to, greater than, etc.), and enter your date value.
Sources: Clay formatters overview | Documentation | Clay University Format Date/Time with Clay Formatters Customize your table view | Documentation | Clay University
Channeled
APP
·
·
Suhaib S.
·
·
best way is to create a formula column with: DATETIME(created_at, "-07:00") That'll shift it to Pacific Time. You can then filter based on that. Let me know if you want help setting it up!
🙌1
Clay
APP
·
·
That's a great approach! You can create a formula column to convert your created_at to Pacific Time. To set this up: 1. Add a new column and select Formula 2. In the AI Formula Generator, enter your formula: DATETIME(created_at, "-07:00") 3. Click Generate Formula and review the output 4. Click Save Formula to apply it Once you have the Pacific Time column, you can filter your table using that converted date column for accurate timezone-based filtering.
Sources: Formulas Formula generator | Documentation | Clay University Clay formatters overview | Documentation | Clay University Customize your table view | Documentation | Clay University
Gabe E.
·
·
Hi Christopher, Are you all sorted here? Please let me know if you're still having issues and how else I can help here! Gabe

Ensure Pacific Time Zone for Table Filtering in Clay App | Clay