Date formatting is not working?

I am having major issues with date formatting. I have tried everything to obtain the time from our datetime fields but it is simply not working. The date is being shown without the time. I have tried custom formatting also. Can someone advise how to resolve please??? This seems a bug with QS. The visual is simply a table with a large number of columns. If i add that field to a new visual table then the datetime appears. :man_facepalming:

Hi @ssbahra
Can you share some screenshots that we can see what you have done so far?
BR

Hi @ErikG This is what i have set and what is being displayed from my large table of data. The field is campaign_date_created

image

If I create a new table visual with just THIS field then the datetime appears. It is using the same Date and Time format as per my screenshots prior.

Within the table the field is set to day or minutes?

Hi @ErikG I am using the Date and Time formats as per my initial screenshots. Is this what you mean? If not, can you advise how I check pls.

Can you check the aggregate of the field?

Hi @ErikG I am using Day in the table where the time is not displaying.

Can you switch to “Minutes”?

Thanks @ErikG That worked!!! :slight_smile:
Thank you so much for your help with this. I was banging my head for days on this.
Life saver!

Perfect you’re welcome. Could you please solve the topic?

1 Like