Date Import Issue- Adding time with date

Question & Answer
, ,
1

@duncan @Max
I have a sample .csv data with date values without time. when I import it to quicksight , it automatically adds time with it . How to overcome this issue ?

1/1/2021
1/2/2021
1/3/2021
1/4/2021
1/5/2021
1/6/2021
1/7/2021
1/8/2021
1/9/2021
1/10/2021

image

2

Hi

You can formate it without the time as given below

image

regards,
Naveed Ali

2 Likes
3

Yeah , We can format it as per needs . But when I try to export visual Data to csv , time is also added to date .So, I am trying to solve this issue while importing date

4

HI,

This the default behaviour of SPICE :slight_smile:

regards,
Naveed Ali

1 Like
6

Hi @Naveed - Can we request QS team when a data is exported to csv and a field contain date, there should be an option for selecting the format. Please advise.

Regards- Sanjeeb

1 Like
7

Hi @SanthoshV

Are you able to export to excel instead as this appears to preserve the formatting used in the visual?

Also, I’ll archive this as a feature request.

Regards,
Andrew