Writing current date as Excel sheet name

Like (0) Share

Report

Posted on 15 Apr 2021 09:01:52 by dwalker97

I am trying to create an Excel worksheet and write the current date as the sheet name.

I am using the formula to get today's date: formatDateTime(utcNow(), 'yyyy-MM-ddThh:mm:ss'), in a Compose, and then writing the output to a variable 'Date'.

I then use a create worksheet and use the 'Date' variable as the Name selection for the worksheet.

I am getting the following error though -

Can anybody help me with this? Thanks 😊

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (1)

dwalker97 82 on 15 Apr 2021 at 10:02:09

Like (0)

Report

Re: Writing current date as Excel sheet name

That works perfect, thank you! I knew it would be something minor. 😅

Was this reply helpful? Yes No
Verified answer

fchopo 7,972 Moderator on 15 Apr 2021 at 09:27:31

Like (1)

Report

Re: Writing current date as Excel sheet name

Hi @dwalker97

An Excel's sheet name can't contain special characters like: /, \, *, : , [], : Worksheets: Naming Conventions – The Excel Codex

In your case, you have the ":" character, so your flow is going to fail. Can you replace ":" by "_", for example?

Hope it helps!

Ferran

Was this reply helpful? Yes No