community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

issue with DateTimeAdd returning null

Meteor

I have a simple formula that returns null for some of the values even though no records have null values for the required variables and inputs are correct data types.

 

 

DateTimeAdd([MX In Date] + ' ' + [LUS_RON_End_Time], 1440 -([Min_GT]*60), 'Minutes')

 

I verified that [MX In Date] is a Date and that [LUS_RON_End_Time] is a time.  If I remove the [LUS_RON_End_Time] then it works.  I have no idea what is causing this issue.  Nothing has changed in the upstream process or raw data.  Any ideas? Thanks

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@byarsmc79,

 

It works for me.

 

Maybe your [LUS_RON_End_Time] has bad data in it?  You can check with:

regex_match([LUS_RON_End_Time],"\d{2}:\d{2}:\d{2}")

This will identify any records without the proper format for the time (note:  it isn't smart enough to identify bad times like 25:70:88).

 

Make sure also that the min_gt is a number.  Otherwise, maybe you can post some data?

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Meteor

All the fields were good,  but now it is working fine even though nothing changed.  I don't get it.  

Labels