Fomatting Date returned in Json Response

Question

I followed the example listed here: How to use Pipelines to email a report at a specific time of day | Qrew Discussions (quickbase.com)

However, my Json reponse includes a date. The example formats Percentage and Currency, but does anyone know the syntax need to format a date data? I need it in the MMDDYYYY format (no time stamp).

Thank you.

Mark

doughenning1 · Answer

If the field includes the date and time, the field type is 'timestamp', otherwise it's 'date'.
So you could add:
{% elif field['type'] == 'timestamp' -%}
&lt;td&gt;{{ record[field['id'] | string]['value'] | date_mdy }}&lt;/td&gt;

Forum Discussion

Fomatting Date returned in Json Response

1 Reply