4

I am trying to get day from date field in quicksight.

Following is date format in quicksight: 2020-09-29T00:00:00.000Z

I want some function which will parse the date and give the day from this date. i.e., Tuesday

Rushabh Sudame
  • 414
  • 1
  • 6
  • 22

2 Answers2

6

In the QuickSight Dataset you can define a Calculated Field.

In your case, e.g. toString(extract('WD',{transaction_date})). This returns the day of the week as an integer, with Sunday as 1. If you need it as a word, you can further translate it with ifelse function.

OpusMagnum
  • 86
  • 1
  • 4
3

You could use formatDate to get the day of week as a string i.e. Monday ... formatDate({datetime}, 'E')

Scott Taylor
  • 31
  • 1