Date function [This year (excluding today)] - What happens on January 1st | Community
Skip to main content
U
user51162
December 18, 2023
Solved

Date function [This year (excluding today)] - What happens on January 1st

  • December 18, 2023
  • 1 reply
  • 1238 views

Hey all, i use a report that provides a new row for each day that i extract and use to build a report. As the end of the year is coming up, i'm not sure how the report will behave with the time filter i have applied which is the pre-set adobe This Year (excluding today) - On January 1st 2024 will this filter identify its 2024 and exclude today hence providing no data or is the 'excluding today' clause actually a priority and it'll still give me a full 2023 dataset (31-12-2023) 

 

Hope this makes sense and hope someone understands! 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

I understand your question... I feel like this is going to result in no data on Jan 1... 

 

You're right, the logic is "this year" which on Jan 1 should be 2024... but with the exclude today, Jan 1 itself won't be included... 

 

Without knowing your use case, I am not sure what alternatives might apply... its too bad we can't have some extra date logic.. like "if Jan 1, then do "last year".

 

Sometimes you have to settle for something more like "last full 365 days", which will pull back more than this year as you are going through, and won't get you a full year on a leap year... but you at least don't get a day with no data... 

If you are using Report Builder and dates from cells, you can build in that complex logic using Excel date formulas....

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
December 18, 2023

I understand your question... I feel like this is going to result in no data on Jan 1... 

 

You're right, the logic is "this year" which on Jan 1 should be 2024... but with the exclude today, Jan 1 itself won't be included... 

 

Without knowing your use case, I am not sure what alternatives might apply... its too bad we can't have some extra date logic.. like "if Jan 1, then do "last year".

 

Sometimes you have to settle for something more like "last full 365 days", which will pull back more than this year as you are going through, and won't get you a full year on a leap year... but you at least don't get a day with no data... 

If you are using Report Builder and dates from cells, you can build in that complex logic using Excel date formulas....

RobertBlakeley
Community Advisor
RobertBlakeleyCommunity Advisor
Community Advisor
December 18, 2023

Yes, on the face of it there would be no data on Jan 1. To confirm, I would send a ticket to Client Care.

U
user51162Author
December 19, 2023

Thanks both for your responses, I'll find a way to adapt. It's only one day's worth of data in the grand scheme of things but understanding the logic helps! 

Terms & ConditionsAccessibility statement

Loading footer...