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?
Page 1 / 1
Hi 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.
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.
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.