Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Subtract 2 Date Types, why duration????

so simple. subtract these 2 dates, format of dates is 1/1/2020, Date type

 

[col1 Date] - [col2 Date]  i get a duration as default output. i tried Int64.Type([col1 date] - Int64.Type([col1 date]

 i get ERROR

 

i need todo a conditional, if > 365 etc

 

= Table.AddColumn(#"Filtered Rows", "New_Existing_Cust", each if Int64.Type([Quarter_Sample_Recvd]) - Int64.Type([Prev Qrt Ordered]) < 365 then "existing" else "new")

 

how can i just get a plain integer output !!!!!

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    Since it's a duration, you can use Duration.Days to convert it to an integer.

     

    = Table.AddColumn(
    #"Filtered Rows",
    "New_Existing_Cust",
    each
      if Duration.Days([Quarter_Sample_Recvd]) - [Prev Qrt Ordered]) < 365
      then "existing"
      else "new"
  )

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    2 years ago

    Since it's a duration, you can use Duration.Days to convert it to an integer.

     

    = Table.AddColumn(
    #"Filtered Rows",
    "New_Existing_Cust",
    each
      if Duration.Days([Quarter_Sample_Recvd]) - [Prev Qrt Ordered]) < 365
      then "existing"
      else "new"
  )
  • slorin's avatar
    slorin
    Super User
    2 years ago

    Hi, 

    Int64.TypeFrom([Quarter_Sample_Recvd])

    Stéphane