Solution to Custom Formatting on Response Date

Solution to formatting a “Response Date” to MM/DD/YYYY.

Creating the field

1. In the survey flow section, choose “Embedded Data”
2. Name the new data something like “Taken Date”
3. Click “Set a Value Now”
4. Navigate to “insert piped text” and find “Date/time” and “Current Date / Time”
5. Open Data & Analysis tab and Column Chooser
6. Under Embedded Data, choose “Taken Date”

Adding field to dashboard

1. Open Dashboard
2. Open Settings
3. In the Dashboard data tab, add a new field
4. Choose Embedded Data, find “Taken Date” and choose Text Value as the field type
5. Save your Dashboard data, give your dashboard a bit of time to update
6. Go to your dashboard and create a Record Table widget
7. Add a column, find “Taken Date”

Adding a field filter in dashboard

1. Ensure you’re in edit mode
2. Click plus button on the top next to filters
3. Add “Survey Metadata - Recorded Date”
4. Click “Done editing”

NOTE: When filtering the dashboard if you want the date picker, instead of choosing to filter on your new field, Taken Date, you’ll choose the meta data field that is formatted correctly. If you try to filter on Taken Date, you will only get the option to filter on keyword.

Back story:

The dashboard I built includes a Record Table widget meant for exporting. This Record table has data in a certain order and dates in the MM/DD/YYYY format. I attempted  to pull in Response Date as a column but I am not able to update the format from MM-DD-YYYY. (dashes instead of forward slashes). I tried the following:

• Creating a new custom field in the survey field editor and setting date there. (cannot concatenate a date field)
• Adding the field as-is to Dashboard data and updating the formatting in the widget settings
• Adding a duplicate field in the data mapping (cannot edit the format of the date in the data mapper for that field)