00:00:00 showing 1899-12-30 00:00:00:00

[Jak82]

For some reason when I bring an Excel time field into Alteryx

If the field is 00:00:00 is it showing it as 1899-12-30 00:00:00:00

Is there anyway round this.. if it has a value like 00:06:00 it seems to be okay?

Thanks

Chris

[Deano478 · Accepted solution]

@Jak82 Have you set the column to a time data type that might be of some help?