Q:
I have different date formats as outputs.
Is it possible to extract just the year and month (yyyyMM) and use them for file names or values?
A: Yes, it is possible!
To extract just the year and month (yyyyMM) from a date, follow these steps:
Obtain the Date and Time
First, use the action that retrieves the date and time you want to extract.Transform the Data
Select the “Extract Data with Regular Expression” action under data extraction. Apply a regular expression to convert the retrieved date into a yyyyMM format.Use the yyyyMM Output
After transforming the date, specify the newly created "yyyyMM" output as the file name for your spreadsheet, or use it as a value in a cell.
📚 Related Guides
✍️ How to Write Regular Expressions - View Guide Here
Search Keywords
Search Keywords
regular expressions, yyyyMM, date format, file name, manipulate data