Forum Discussion

Havard's avatar
Havard
Frequent Visitor
5 years ago
Solved

Find if a date from API is YTD or LYTD

I'm really new to this. I can't find how to do what's marked with BOLD. I would be very happy if anyone could help med with this:   if [postingDate] >= #date(ThisYear, 1, 1) and [postingDate] <= #d...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    That is how you do it. The clean code would be something like this Havard 

    let 
   varToday = Date.From(DateTimeZone.FixedUtcNow())
in

if [postingDate] >= Date.StartOfYear(varToday) and [postingDate] <= varToday

then "YTD"

else if [postingDate] >= Date.AddYears(varToday,-1) and [postingDate] <= Date.AddYears(varToday,-1)

then "LYTD"



     

Havard's avatar
Havard
Frequent Visitor
5 years ago

I Ifinally solved it, but it's bit of .."clumsy". I have seen a code with Let, but don't know how to go from there to if...

 

if [postingDate] >= Date.StartOfYear(Date.From(DateTimeZone.FixedUtcNow())) and [postingDate] <= Date.From(DateTimeZone.FixedUtcNow())

then "YTD"

else if [postingDate] >= Date.AddYears(Date.From(DateTimeZone.FixedUtcNow()),-1) and [postingDate] <= Date.From(Date.AddYears(Date.From(DateTimeZone.FixedUtcNow()),-1))

then "LYTD"

else "BLANK"

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

That is how you do it. The clean code would be something like this Havard 

let 
   varToday = Date.From(DateTimeZone.FixedUtcNow())
in

if [postingDate] >= Date.StartOfYear(varToday) and [postingDate] <= varToday

then "YTD"

else if [postingDate] >= Date.AddYears(varToday,-1) and [postingDate] <= Date.AddYears(varToday,-1)

then "LYTD"



 

  • Havard's avatar
    Havard
    Frequent Visitor
    5 years ago

    Thx a lot! It's easier to see the "language" now. 

    • edhans's avatar
      edhans
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Excellent Havard - you definitely have the concepts down. Once I figured out how to use variables like this my code got much smaller and easier to edit/read.

    • Havard's avatar
      Havard
      Frequent Visitor
      4 years ago

      I thought this worke, but does not. Can somoen pls help me? Im NO good to this;)

       

      if [postingDate] >= Date.StartOfYear(Date.From(DateTimeZone.FixedUtcNow())) and [postingDate] <= Date.From(DateTimeZone.FixedUtcNow())
      then "YTD"
      else if [postingDate] >= Date.AddYears(Date.From(DateTimeZone.FixedUtcNow()),-1) and [postingDate] <= Date.From(Date.AddYears(Date.From(DateTimeZone.FixedUtcNow()),-1))
      then "LYTD"
      else "BLANK"