see the attached workflow which does exactly what you were looking for.
The last day of the month date is produced as a date/time data type. To output the same date as a string in the exact format you need, you have to append a Date Field Extractor node and then a String Manipulation node to generate the final string.
Hi Marco - thanks a lot for the workflow below! It does exactly what I need bar the first node - Table Creator. I require the workflow to work off a blank cell and identify the date it is being run on - and not for it to run off a previously defined date.
I effectively need a node that will date stamp based on the day it is running and and populate the cells with said date. After that, I can put your workflow in to get what I need. Is this possible? I've tried a majority of the date nodes and Extract System Properties to no avail.
that's easy to achieve using a Time Generator node. Just make sure you reset the node each time you run your workflow so it update its output to the current date. See the attached modified workflow.