How to check two date field values are null

[Heena]

Hi All,

I have the data as below, just few records as ex.

EID	T_Start_D	Due_D
1	1/22/2018
2	2/23/2017	_
3	_	9/23/2017
4	3/6/2019	2/23/2011
5	2/23/2017	9/23/2007
6	2/23/2017	2/13/2008
7	_	_
8	2/23/2017	2/23/2017

In Straight table, I need to show if the fields 'T_Start_D' and 'Due_D' are having values as Null or (_) values show as 'Not Required'

Thanks & Regards,

Heena Kauser

[Anil_Babu_Samineni]

Try this?

If(IsNull(T_Start_D) or Match(T_Start_D, '_'), 'Not Required') -- for T_Start_D

If(IsNull(Due_D) or Match(Due_D, '_'), 'Not Required') -- for Due_D

[Heena]

Hi ,

I tried this below, Not working.

=if(
(If(len(trim(T_Start_D))= 0 , 'Not Required') )
and
(If(len(trim(Due_D))= 0 , 'Not Required') )
,'Not Required')

Thanks & Regards,

Heena Kauser

[Anil_Babu_Samineni]

Null part may work but not "_" one since Len('_') calculate as 1. So, It is false. 

Anyway, Did you try mine?

[Heena]

Hi,

=If(IsNull([Due Date]) and
IsNull([Target Audience Start Date])
, 'Not Required')

Not working.. I need both fields

Thanks & Regards,

Heena Kauser

[Heena]

Sorry, My Bad. Its NULL '-' only, I have typed as '_'

[Anil_Babu_Samineni]

Are you expecting similar below image? If so, use expression as follows

If(Len(T_Start_D)=0 or Match(T_Start_D, '-') or Len(Due_D)=0 or Match(Due_D, '-'), 'Not Required')

[Heena]

Hi,

I need this as below.

EID	T_Start_D	Due_D	Expected
1	1/22/2018
2	2/23/2017	_
3	_	9/23/2017
4	3/6/2019	2/23/2011
5	2/23/2017	9/23/2007
6	2/23/2017	2/13/2008
7	_	_	Not Required
8	2/23/2017	2/23/2017

Thanks & Regards,

Heena Kauser

[Heena]

Hi,

I tried, I am not getting the correct result.

the expected result I want is, if both date fields are Null, then the calculated field should be  shown as ' not required'.

Thanks & Regards,

Heena