Hello,
I'm trying to use the "dateOfWeek" function to return the day of a timestamp.
I would then like to write a certain value into a specific field, based on the returned day of week.
Example:
- timestamp returns 2 (Tuesday) => I want to write myValue ("Duration") into the column "Tue" of the Excel file
- timestamp returns 5 (Friday) => I want to write myValue ("Duration") into column "Fri" of the Excel file
I've added a screenshot of the fields.
Any help would be appreciated.
Thank you.
