how to get data for two previous weeks and current date data with a formula
- 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 , i need to get a data filtered out for the current date along with the previous two weeks of data .. could someone help me with the formula. Attached my document .. i need to get it filtered in Go LIVE date column.
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
There's many different ways to do this; the datetimediff function within a formula tool should give you what you need...
datetimediff([Go Live Dt],datetimetoday(),'days') >= -14
AND
datetimediff([Go Live Dt],datetimetoday(),'days') <= 0
Though this does -14 days, the solution may need to change slightly if you are looking for the previous 2 weeks in terms of week numbers.
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use a filter tool with a custom filter:
[Go Live Dt] = ToDate(DateTimeAdd(DateTimeToday(), -13, "days")) AND [Go Live Dt] <= Left(DateTimeToday(),10)
That will be last two weeks including today (excluding 14 days ago)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much
