79168075

Date: 2024-11-07 21:09:43
Score: 5.5
Natty: 6.5
Report link

What if there will be a NULL values? How do you change the expression to handle NULL?

(DT_DATE)(SUBSTRING([BirthDate], 1, 4) + "-" + SUBSTRING([BirthDate], 5, 2)+ "-" + SUBSTRING([BirthDate], 7, 2))

I tried this one but not working. (ISNULL(availability_start) ? (DT_DBTIMESTAMP)NULL :(DT_DATE)(SUBSTRING([BirthDate], 1, 4) + "-" + SUBSTRING([BirthDate], 5, 2)+ "-" + SUBSTRING([BirthDate], 7, 2))

Reasons:
  • Blacklisted phrase (1): but not working
  • Blacklisted phrase (1): How do you
  • Blacklisted phrase (1): :(
  • No code block (0.5):
  • Contains question mark (0.5):
  • Starts with a question (0.5): What if the
  • Low reputation (1):
Posted by: Meet Bardoliya