Your function expression contains an unsupported date

Q&A
, , ,
1

I have a Date datatype field in my dataset, I have created below calculated field to extract month name ,year, week from date

  1. formatDate({departure_date},‘yyyy’)
  2. formatDate({departure_date},‘MMMM’)
  3. formatDate({departure_date},‘ww’)
    But when I use these calculated fields in visual I get the error “Your function expression contains an unsupported date”
2

Hi @Tanu_13,
Are you trying to just grab specific portions of your date from a full date field? If so, maybe you could try the truncDate function instead?

Additionally, you can refer to the documentation below for supported date formats in Quick Sight:

Let me know if you have any additional questions!

3

Hi @Brett , the date field is using supported format yyyy-mm-dd, My purpose requires use of formatDate and not truncDate
I need three calculated fields, for year , for month_name, for week_number.
The calulated fields are saved successfully without errors but I dont why error appears when i try to use them in filter or visual.

4

Hi @Tanu_13,
Interesting, could you share a bit more about the scenario…what type of visual are you trying to build, what fields are being utilized within the visual (feel free to share a picture of the fields in the field well so that I can see where they’re being used as well) and are there any filters being utilized on the visual?

5

20250813_154116
20250813_1541161920×885 260 KB

If I create any visual using the calculated fields mentioned earlier,I get such error

6

Hi @Tanu_13,
If you’re using a supported date format and still receiving this error, this may be a system bug you’re encountering. I would suggest creating a support ticket so that you can get more direct assistance with your account.

7

Hi @Tanu_13,

Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions or were you able to find a work around for your case?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

8

Hi @Tanu_13,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!