Quicksight date format issue

0

So I have a set of business data that I would like to visualize in Quicksight. And some of the date formats are like - 0001-01-01 00:00:00 . Which is not being accepted by Quicksight. This set of date format is very important for the business and can't be excluded. Is there any way to display this? Whenever this format comes, no data is being loaded in Quicksight

Naveen
質問済み 2ヶ月前116ビュー
2回答
0

I would reevaluate using that date and using something else.

profile picture
エキスパート
回答済み 2ヶ月前
0

Hi Naveen, You can manually customize the date format like yyyy-mm-d HH:mm:ss following the steps on this link Format a date field

When you choose the Custom in the Date and Time sections, expand the Custom section and specify the format pattern that you want, using the format pattern syntax specified in Moment.js Display Format in the Moment.js Display Format documentation.

I hope it helps,

profile pictureAWS
BezuW
回答済み 2ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ