How to show date values based on condition?

[#1]

Hi,

I want to show Dates when the below condition satisfy

when DateA is blank the expression should show DateB value other wise it should show DateA value. I have used below seems not working.

=Date(If((DateA='',DateB,DateA),'DD/MM/YYYY')

Please can anyone suggest me how to change this.

Thanks.

[buzzy996 · Accepted solution]

try tis way,

=Date#(If(isnull(DateA),DateB,DateA),'DD/MM/YYYY')

[jpenuliar]

Hi Amelia,

Depends on your field whether  Blank(empty) or Null.

see which apply to your case:

Len(DateA) = 0 or Isnull(DateA)

[#4]

Thanks. working.

[buzzy996]

ur wc