Timestamp from Form Submission

Hi!

I am using the “Send an internal email…” Template in Shopify Flow to receive an email when someone submitted a form that I created with Shopify Forms. In the email I would like to include the full time stamp when the form was submitted (date + hh:mm). However, I was not able to find a way to do so. I know that there is the metaobject.formSubmittedAt variable which hands over the date. Is there a way to also get the time (hh:mm) when the form was submitted or do I have to manually look it up?

Thanks

Hey @hello_3340

The formSubmittedAt variable actually contains a full ISO 8601 timestamp including the time, Flow just renders it as date only by default. You can format it however you want using the Liquid date filter inside your email template. Try this:

{{ metaobject.formSubmittedAt | date: "%Y-%m-%d %H:%M" }}

That outputs something like 2026-05-14 14:32. If you prefer a more readable format, swap the format string, for example "%B %d, %Y at %H:%M" gives you May 14, 2026 at 14:32. One thing to note, the time is in UTC by default.


Hope that helps! If it did, a Like and Marking it as Solution goes a long way and helps others find the fix faster too.

Best,
Moeed

Hi @Moeed

Thank you for the tip! That is what I was looking for. However, while the date is displayed correctly, I do not get any time other than 00:00. Is there anything else I need to add? Also, is there an easy way to display the time in a different time zone, like CET/CEST?

Thanks,
Thomas

Ah, that’s a trick of how Shopify Forms exposes the metaobject field, formSubmittedAt is sometimes stored as a date-only field rather than a full datetime, which is why the time portion always shows 00:00 regardless of the format string. Annoying but it’s coming from the source, not the filter.

Quick workaround: instead of using formSubmittedAt, use the current run time of the flow itself, which is basically identical to the submission time since Flow fires within seconds of the form being submitted. Try:

{{ "now" | date: "%Y-%m-%d %H:%M" }}

That’ll always have a real time component.

For CET/CEST conversion, Flow doesn’t have a native timezone filter so you have to manually offset. CET is UTC+1, CEST is UTC+2 (summer). Use:

{{ "now" | date_plus: "2 hours" | date: "%Y-%m-%d %H:%M" }}

Adjust to "1 hour" during winter time. There’s no clean way to handle DST switching automatically in Flow unfortunately, you’d either pick one offset and accept the hour error half the year, or build a conditional check on the date to switch between 1 and 2 hours. For most internal notifications, just picking +2 hours and noting it’s CEST is the pragmatic call.

Best,
Moeed

That solved it! Thank you very much!
I can absolutely live with either the time stamp being one hour off for half the year or adjusting the offset in Flow twice a year. The solution is good enough for my needs.

Thank you for your reply. I’m glad to hear that the solution worked well for you. If you require any more help, don’t hesitate to reach out. If you find this information useful, a Like would be greatly appreciated.

Cheers,
Moeed