OUTPUT IN XLS STILL SHOWS INCORRECT DATE FORMAT

[kathbanc]

Hi! 

Can you help me again. 

Datatype already changed to DATE only. 

Browse tools shows correct data, 

but when I output it into XLS , the minutes and seconds still showing. 

[FrederikE]

Hey @kathbanc, 

Converting it to a string and then to a date again (w. seperate tools) might help. Saving it as a string (if this is possible) will also work. 

Also, why are you saving to a .xls? Could you try it with a .xlsx instead? 

[binu_acs]

@kathbanc Add a select tool after the input tool then try again

[kathbanc]

Yes , already tried this. But still the same

[kathbanc]

Hi!, 

yes my filetype is already .xlsx. 

[binu_acs]

@kathbanc @Have you tried the workflow which I sent to you?

[binu_acs · Accepted solution]

@kathbanc Try the attached workflow

[kathbanc]

It works!! thank you so much