Formula Help - If Time

Question

I am trying to build a formula for what day we record shipping product.  If we ship product before 21:00:00 we count that as same day and if it ships after 21:00:00 it would count towards the following day.  I have the following built but am getting [Null] in my output.  Not sure what I am missing - DateTime_Out is Time type and SHIPMENT_DATE is Date Type if that helps.

IF [DateTime_Out] < "21:00:00" THEN DateTimeAdd(DateTimeParse([SHIPMENT_DATE],"%d-%b-%y"),+1,"days") else [SHIPMENT_DATE] ENDIF

All suggestions / insights are appreciated!

DawnDuong · Answer

i suspect the issue is with the field [Shipment date]. If that is not of the right type, the output is null, even then the "if conditions" part works.

ChrisTX · Answer

In the Results window screen shot below, the field data types are Date, Time, Date, String

The formula testing the Time field, and adding 1 to the Date field seems to be working  OK.

Chris

DawnDuong · Answer

hi @dmill8023

My guess is there is some confusion between Date, DateTime and Time formats between the various fields.

If we impose a Time format on a Date field (or vice versa impose a DateTime or Date format on a Time field), the value will be [null].

Dawn.

TimeFormat.yxmd