need to convert each date in the two columns to the start date of the month.
For every date in February I need 01.02.2020 and for every January 01.01.2020 and so on.
How exactly do I do that in Uipath?
A detailed description (preferably with screenshots) would be incredibly great, because I have only been dealing with Uipath for a short time and am not particularly good.
I have an excel list that includes a posting date and goods issue date for each invoice. Now I would like to check whether the posting date is in the previous month of the goods issue date in order to reveal any fraud.
My idea was to determine the start of the month for each date and then to be able to check if posting date <goods issue date with an if formula.
It is important to check whether the posting date was in the previous month, as this would distort the month-end closing. so you can’t just check if it’s smaller
Excel Application Scope with workbook path of the Excel sheet
Read Column with the Sheet and the Column where my Dates are. And Output in strDate (for Goods Issue Date Column) and strDate1(for the Posting Date column) ?
Please excuse the many questions, but as you can see I’m really very new to uipath.
So the steps are:
Excel Application Scope with workbook path of the Excel Sheed.
Read Range
But how do I tell uipath that I want to get the column posting date and goods issue date from the excel sheet and how do I store them in a variable and what type of variable do I have to select?