Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Calculated Column for Date Codes with Blanks

I have two date columns that I am attempting to find the difference between. The issue is that about 1/3rd are missing at least one date. Would like the calculated column to zero out the whole formul...
Need Help
  • uzuntasgokberk's avatar
    uzuntasgokberk
    1 year ago

    Hello Anonymous ,

    You can change the measure like this:
    "
    measure =
    IF( ISBLANK([start_date2]) || ISBLANK([start_date1]), 0, [start_date1] -[start_date2])
    "

    Kind Regards,
    Gรถkberk UzuntaลŸ

    ๐Ÿ“Œ If this post helps, then please consider Accepting it as a solution and giving Kudos โ€” it helps other members find answers faster!

    ๐Ÿ”— Stay Connected:
    ๐Ÿ“˜ Medium |
    ๐Ÿ“บ YouTube |
    ๐Ÿ’ผ LinkedIn |
    ๐Ÿ“ท Instagram |
    ๐Ÿฆ X |
    ๐Ÿ‘ฝ Reddit |
    ๐ŸŒ Website |
    ๐ŸŽต TikTok |

uzuntasgokberk's avatar
uzuntasgokberk
Icon for Super User rankSuper User
1 year ago

Hello Anonymous ,

You can change the measure like this:
"
measure =
IF( ISBLANK([start_date2]) || ISBLANK([start_date1]), 0, [start_date1] -[start_date2])
"

Kind Regards,
Gรถkberk UzuntaลŸ

๐Ÿ“Œ If this post helps, then please consider Accepting it as a solution and giving Kudos โ€” it helps other members find answers faster!

๐Ÿ”— Stay Connected:
๐Ÿ“˜ Medium |
๐Ÿ“บ YouTube |
๐Ÿ’ผ LinkedIn |
๐Ÿ“ท Instagram |
๐Ÿฆ X |
๐Ÿ‘ฝ Reddit |
๐ŸŒ Website |
๐ŸŽต TikTok |

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Perfect. Thank you very much.