Hello,
I am using the Query Data module in an Action Flow. The output of the various date fields appears as below - instead of a regular date format like YYYY-MM-DD.
How can I change the output of the column in Query Data?
Solved
How to change date field's output in 'Query Data' module
+11Best answer by matt.witty13
Hi Vincent,
This is an unfortunate output in the Query Data Module. It outputs in epoch/unix units for time. To get it to the format you're suggesting, use the Tools module and use the formatDate() function like this:
Or however you want the date to be formatted.
+1Hi Vincent,
Try using ROUND_DAY(COLUMN NAME)
Thanks
Muthappan
Hi Vincent,
This is an unfortunate output in the Query Data Module. It outputs in epoch/unix units for time. To get it to the format you're suggesting, use the Tools module and use the formatDate() function like this:
Or however you want the date to be formatted.
+11Hi Vincent,
This is an unfortunate output in the Query Data Module. It outputs in epoch/unix units for time. To get it to the format you're suggesting, use the Tools module and use the formatDate() function like this:
Or however you want the date to be formatted.
Thank you Matt this worked!
Query data --> Set variable --> Get variable --> Create CSV --> Send email
Thank you Matt this worked!
Query data --> Set variable --> Get variable --> Create CSV --> Send email
Awesome! I will say you won't need to use the Get Variable module. You should be able to access it in the Create CSV module.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.