Dateonly gives #invalid Data Type

[Received Time] is pulling the first datetime from [NAXML(1)]. Then [Received Date] is trying to pull just the date from [Reveived Time]. I'm getting the #Invalid Date Type error and I'm guessing it is becasue it isn't seeing the value in the [Received Time] cell, just the formula?

Best Answer

  • Garrett Henke
    Garrett Henke ✭✭✭✭✭
    edited 07/15/21 Answer ✓

    @Scott Saxton

    Ok since NAXML is a static value you can use it to break down the needed information. I used the same formula that you used to calculate the Received Time. I then used =LEFT([Received Time]@row, FIND(" ", [Received Time]@row)) to pull the date only from the Received Time value. I tried setting NAXML(1) as a Text/Number column and a Date column and both worked. Received Time and Received Date are set as date columns. Hope this helps!