Forum Discussion

B00m3r's avatar
B00m3r
Frequent Visitor
8 years ago
Solved

datediff between install date and todays date

I have 20,000 assets in an excel spreadsheet, when an asset is installed it generally is tagged with an install date in the excel file. Unfortunately, around 60% of the assets don’t have an install d...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi B00m3r,

     

    I'd like to suggest you modify the formula to replace these exception date if you haven't find out a method to deal with them.(e.g. 0)

    Days BTWN todays date v shipment date =
IF (
    CMDB[Todays Date] >= CMDB[Shipment Date],
    DATEDIFF ( CMDB[Shipment Date], CMDB[Todays Date], DAY ),
    0
)

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi B00m3r,

 

I'd like to suggest you modify the formula to replace these exception date if you haven't find out a method to deal with them.(e.g. 0)

Days BTWN todays date v shipment date =
IF (
    CMDB[Todays Date] >= CMDB[Shipment Date],
    DATEDIFF ( CMDB[Shipment Date], CMDB[Todays Date], DAY ),
    0
)

 

Regards,

Xiaoxin Sheng

  • B00m3r's avatar
    B00m3r
    Frequent Visitor
    8 years ago
    Mr Sheng
    Im very grateful for your response which worked perfectly, much appreciated.
    Season Grettings.