Renaming Header - Removing Date
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi guys,
I have this header "Report: Daily Revenue Retail for 6/19/2024". I used the dynamic rename to rename this header and it works however, it gives an error every time I update my input file. The reason of the error is because the date update to 6/20/2024 and so forth. This is a daily report. Is there a way we can do to allow updating the input file without causing an error? I would like to rename the header to "Date".
Below is the configuration i used for dynamic rename.
 
Thanks and hoping to hear from anyone.
Kamen
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Date Time
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
try this formula
IF CONTAINS([#1], "Report: Daily Revenue Retail for") THEN
"Date"
ELSE
[#1]
ENDIF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
in you dynamic rename - you have to select your fields to change. You'd want to select your current date field (the 6/19 field in your picture) and select the dynamic/unknown fields checkbox at the end of your list. Then you will apply your logic to all new fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/12A9B4B958288E867BE947DD48612FB8/responsive_peak/images/icon_anonymous_message.png)