Creating a Date Range

I have the following WF -- Where Im able to pull a range of dates ( Batch GL Date) but I just want to capture a range of it..

Lets said I just need to capture the data from Jan 1, 2021 thru April 30, 2021. I'll also will like to turn it into an app -- where the end user can input the dates as well

Attached is the WF

GL Date Range.yxmd

Tips and Tricks

Date Time

Accepted answers

apathetichell

Hi!

Right now your dates are not dates - they are strings with date like properties. If you want to use date tools/formulas with them you'll need to convert them as I did in the attached worfklow. I then filter out the original string columns to only include the date columns at attach a filter at the specified dates.

Now - for the second part - allowing a user to enter information. You'll need to add two calendar interface tools and an action tool and attach that to the filter tool and set them to update specific pieces of the filter tool. Add a browse and voila.

gl date range.yxwz

Qiu

@apathetichell
Nicely done! 😁

apathetichell

Sorry, I'm still not 100% clear on what you're looking for. I went back to my version of the workflow because there are still some data errors on select based conversion on that one. This one now sums up a beginning balance and ending balance at a filtered date (12/31/2020) and one to the present. It renames both sums and then creates one set of records with all four fields.