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.
I have a dataset that looks like below. How would I use either "DateTimeNow" or "DateTime_Out" to dynamically select ONLY the "Jun-18", but would choose Aug-18 when the DateTimeNow/DateTime_Out is in August? Any ideas are welcome! Thanks.
@akihirokomatsu The "Dynamic Select" tool would suit your purposes. In this instance, set the configuration to be "Select via a Formula."
Note that this is setup to choose the current month field and not to your "DateTime_Out" function but if you wanted the previous month adding a datetimeadd function to the beginning would not be difficult.
Also in this case you wouldn't necessarily need the datetimenow or dateimteout fields as alteryx is aware of the current time and can use that in a function.