Forum Discussion

ChelseaLearned's avatar
ChelseaLearned
Frequent Visitor
3 years ago
Solved

Created Date is within Current Week, Past Two Weeks, etc.

Hi Everyone   Thanks for reading!  I'm trying to create an open ticket tracker that shows tickets as green, yellow, orange, and red depending on if they're just open in the current week, past two w...
Need Help
  • ChelseaLearned's avatar
    ChelseaLearned
    3 years ago

    Thanks for your help!  I found out what I initially did actually worked, just the preview wasn't loading all data.  I had to click "Load more" when selecting the dropdown for the calculated column.

amitchandak's avatar
amitchandak
Super User
3 years ago

ChelseaLearned , Try this in a new column. Trying to use date, in the place of date time

 

let
_create = DateTime.Date([Created Time]),
_result = if _create is null then null else if Date.IsInCurrentWeek(_create) then "Current Week" else if Date.IsInPreviousNWeeks(_create, 2) then "Past Two Weeks" else if Date.IsInCurrentMonth(_create) then "Past Month" else "Older Than a Month"

in
_result