Skip to main content

Clockforce

Meeting time finder, timezone comparison and MCE date conversion tool. Let it handle the timezone math so you can focus on building your automations.

Clockforce is a free, browser-based tool that solves two everyday problems for people working across timezones:

  1. Finding the right meeting time — compare timezones side by side on a visual timeline, save time ranges as shareable Time Blocks, and coordinate across organizations without sharing calendar access.
  2. Handling MCE server time — Salesforce Marketing Cloud Engagement operates on fixed UTC-6, which complicates date logic. Clockforce converts timestamps instantly and generates production-ready SQL, AMPScript, and SSJS code snippets for your automations.
You Should Know

The app code is 100% AI generated as a part of my exploration of AI capabilities in software development. If you find any issues or have suggestions, please feel free to contribute on GitHub or let me know on LinkedIn.

Open App

Timezone Collaboration Without Calendar Access​

Working across timezones is a daily reality for global teams - but finding a good meeting time shouldn't require access to everyone's calendar. Clockforce gives you a visual, one-week timeline where you can compare timezones side by side, see sunrise and sunset for each location, and instantly spot overlapping working hours.

You ca select a time range on the timeline, save it as a named Time Block, and share it via URL. The recipient sees the exact same view — your proposed times mapped to their local timezone - without needing an account, installing anything, or sharing calendar access. This makes it ideal for cross-organization coordination where tools like Google Calendar or Outlook aren't shared.

Time Blocks are especially useful for multi-timezone planning with customers, consultants or platform support specialists: save your team's availability window, share the link in a Slack channel or email, and let everyone see what that window looks like in their timezone.

The UTC-6 Challenge​

MCE's server time is always UTC-6, regardless of Daylight Saving Time (DST) changes. This means that during DST periods, the server time does not adjust, which can lead to discrepancies when scheduling or personalizing communications based on local times. It also makes it tricky to work with date data in SQL, AMPScript, or SSJS, as you need to manually account for timezone differences and DST adjustments.

This app allows you to paste a raw system date from Query Studio or Data Extension and instantly see what that moment was across all your added timezones. It effectively bridges the gap between fixed server timestamps and your local audience's reality.

Script Generation Engine​

One of the standout features of this tool is the ability to generate production-ready SQL, AMPScript, and SSJS code snippets for your Marketing Automation needs.

The generated codes adapts to selected timezones and handles DST logic, so you can implement it directly into your automations without worrying about the underlying complexity. It also provides option to set custom DST boundaries for accurate conversions regardless of your target timezone DST timeframe.

MCE SQL​

The generator leverages the AT TIME ZONE function to handle offset information. It specifically uses the Central America Standard Time workaround to account for MCE's lack of DST.

AMPScript & SSJS​

The tool provides dynamic datetime conversion logic. Since AMPScript & SSJS do not natively handle timezone objects, the generated code uses one of three approaches:

  1. Simple DateAdd: When you convert to UTC (no DST).
  2. SystemDateToLocalDate: When you convert to your local time (assuming you have the same timezone selected on your user in MCE).
  3. Manual Summer Time (DST): DST boundary variables that you can update to ensure accuracy throughout the year for all other timezones.

Key Features​

  • Interactive Timeline: Horizontal one week timeline with draggable time indicator, range selection, sunrise/sunset visualization, and past-hour marking for finding the best meeting times across timezones.
  • Time Blocks: Save and name time ranges on the timeline. Click a block to preview it across all timezone rows with start/end times. Total duration automatically calculated. Shareable via URL with colleagues outside your organization across the globe.
  • Floating Datetime Picker: Lock all clocks to any point in time in any timezone — switch the reference timezone with one click to see conversions instantly.
  • MCE Date Conversion: Paste a raw MCE system date to sync all clocks to that specific point in time.
  • Timeline + Clocks Views: Toggle between the interactive timeline and analog clock faces with real-time digital readouts.
  • 12h / 24h / Mix Format: Choose between 24-hour, 12-hour, or Mix mode that uses the conventional format per timezone.
  • Instant Script Generation: Autogenerated snippets for SQL, AMPScript, and SSJS to handle timezone shifts.
    • DST-Aware Logic: Automatically detects if a target timezone is in Summer/Winter time and suggests appropriate offsets.
  • Save / Load / Share: Save configurations to browser, export/import as JSON, or share via URL.
  • Custom Timezone Names: Add custom timezone label in timezone serach sidebar.
Open AppOpen GitHub