Exclude null dates from dataset

Q&A
, , ,
1

I am working on creating a dataset and would like to filter out certain rows where dates are null. Putting a filter on the dataset does not give me the option to chose null, only a date range. I found another qa and the solution was to create a calculated column, i tried that and am getting syntax errors. ifelse({PaStrtDt} is NULL, ‘null’, {PaStrtDt}) How do I exclude null dates in the dataset?

2

Hi @Jill,

Welcome to the Quick Community! Although not a calculated field solution, I would definitely recommend trying the workaround from this older post, as I feel it may bring you to the same solution. If not though, please let me know and we can see if there is a way to revise yours or create a new calculated field for your question.

Thank you!

3

I looked into that option. But I am trying to create 3 datasets, one based on create date, one based on closed date, and one for pending.

I wanted to exclude null dates in the dataset and then bring the 3 datasets into the analysis.

4

what i’m trying to do. i have a table that has allegation start date and preliminary start date. preliminary is a phase of allegation. if the preliminary start date is null, then i know it’s still in the first phase. i want my dataset to be reflective of those that are in the first phase only. my plan was to create 3 data sets (based on start date, based on closed date, and based on pending)

5

Hi @Jill,

Apologies for the long delay in response, and thanks for clarifying further on your use case. I just realized that you are receiving a syntax error for the calculated field since you are not utilizing the correct function for null check. Try the calculated field below to see if it this removes the null dates:

ifelse(isNull({PaStrtDt}), 0, 1)

If this does not work, please let me know and we can keep reworking to see if we can find a correct calculated field solution.

Thank you!

6

Hi @Jill,

Just checking back in since this thread hasn’t received a response in a while. Was my most recent reply helpful to you and/or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!

Thank you!