This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I am trying to built a flow that is pulling data daily. I only want today's date to pull when the data comes in so I'm trying to build a formula to do that. I am using the DataTimeFormat functions of now. Not sure how to input the data to only get today's date though. Any suggestions?Thank you in advance.
Okay I looked at the data in the output tool, I noticed it still has all dates. I'm needing it to just pull today's date. In the formula tool I did [field name]=DataTimeNow(). What am I doing wrong? Thank you
@Plewis1 make sure the date field in your workflow is coming across as a date data type along with the DateTimeNow() field that you're creating in a formula tool. In the filter tool you'll have to use a custom filter similar to what I created in the sample workflow attached here. Hope this helps!
@Plewis1 Date Fixed is a field that I created in my example since the text input had to be converted to a date. If you follow my example though and create a DateTimeNow field with the formula tool and compare that to the dates that are coming through your workflow via a filter tool you'll be able to keep what you want ([YourDateField]=[DateTimeNow]). If you're still running into issues maybe you can attach a sample of your workflow?