Time format is displayed inconsistently

I loaded data from excel sheet. Some time is shown different format

Hi Balu,

if possible can you provide a sample excel and the Oml file.

for better understanding.


try to force your date attribute with FormatDateTime funtion inside your upload action.

Best Regards.

Hi Balu,

Check the Structure you use for importing the Excel: is the Attribute of type Time (or Date Time) or Text? If Text, you should change it to Time or Date Time.

@Mauro: The Platform uses the default display for dates when not using FormatDateTime or the like, but I've never seen a case where it just picks one or the other.