# If Null Then \[Date\] Statement

**URL:** <https://connect.superhuman.com/t/if-null-then-date-statement/23392>\
**Category:** Ask the Community\
**Created:** [May 12, 2021, 11:15pm UTC](https://connect.superhuman.com/t/if-null-then-date-statement/23392 "2021-05-12T23:15:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Catherine\_Theriault1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/catherine_theriault1/32/19197_2.png) [@Catherine\_Theriault1](https://connect.superhuman.com/u/Catherine_Theriault1)\
**Post date:** [May 12, 2021, 11:15pm UTC](https://connect.superhuman.com/t/if-null-then-date-statement/23392/1 "2021-05-12T23:15:56Z")

</div>

Hi coda community!

Not sure if anyone has any pointers-- I’ve been struggling on writing a sort of If/Then statement in coda.

Essentially I have two different columns containing a date. If the first date column is empty I want to return the date of the second column, otherwise I want the date from the first column in the new “combined date” column I created.

I’d normally go about it by doing something like this:  
If [column 1 date] is null then [column 2 date] else [column 1 date] end as combined\_date.

Thanks!

 ![Screen Shot 2021-05-12 at 7.07.48 PM](https://global.discourse-cdn.com/coda1/original/3X/2/a/2ab987efb8ed58703c007b9f89814deb3308b13a.png)

---

<div class="post-metadata">

**Author:** ![Catherine\_Theriault1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/catherine_theriault1/32/19197_2.png) [@Catherine\_Theriault1](https://connect.superhuman.com/u/Catherine_Theriault1)\
**Post date:** [May 13, 2021, 1:00am UTC](https://connect.superhuman.com/t/if-null-then-date-statement/23392/2 "2021-05-13T01:00:42Z")

</div>

Figured it out!

Including the solution in case anyone has a similar question/issue in the future.

If(IsBlank(thisRow.[column2 date]),thisRow.[column1 date],thisRow.[column2 date])

 ![Screen Shot 2021-05-12 at 8.58.04 PM](https://global.discourse-cdn.com/coda1/original/3X/1/b/1bc847b0cda0641e3df5b93fafa69378baae9a06.png)
