# Formatting Date in Title and Sub Title

**URL:** <https://community.amazonquick.com/t/formatting-date-in-title-and-sub-title/32655>\
**Category:** Q&A\
**Tags:** Business-Intelligence-Engineer, formatting, quick-sight\
**Created:** [July 16, 2024, 4:03pm UTC](https://community.amazonquick.com/t/formatting-date-in-title-and-sub-title/32655 "2024-07-16T16:03:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Saurabh](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@Saurabh](https://community.amazonquick.com/u/Saurabh)\
**Post date:** [July 16, 2024, 4:03pm UTC](https://community.amazonquick.com/t/formatting-date-in-title-and-sub-title/32655/1 "2024-07-16T16:03:53Z")

</div>

I am having a visual, where i have a added a parameter of type Date like below

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/3/1/31e7ebb2a3d95b3c1f7512f0919d14b12870c148.png)  
When i use this parameter in Sub Title of visual, it is displayed as “2024-06-30”  
Is there any way to format it.  
I want to format it like in finnish language. “30.06.2024”  
Is there any way to do this?

---

<div class="post-metadata">

**Author:** ![murili](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/murili/32/21621_2.png) [@murili](https://community.amazonquick.com/u/murili)\
**Post date:** [July 16, 2024, 4:45pm UTC](https://community.amazonquick.com/t/formatting-date-in-title-and-sub-title/32655/2 "2024-07-16T16:45:18Z")

</div>

> [@Saurabh](#):
>
> When i use this parameter in Sub Title of visual, it is displayed as “2024-06-30”  
> Is there any way to format it.  
> I want to format it like in finnish language. “30.06.2024”  
> Is there any way to do this

Yes, you can format the date displayed in the subtitle of a visual in Amazon Quick Sight. Here’s how you can do it:

1. In the Quick Sight visual editor, locate the visual where you want to format the date in the subtitle.
2. Click on the visual to select it, then click on the “Format” tab in the right-hand panel.
3. In the “Subtitle” section, you should see the date field that is currently being used. Click on the date field to open the format options.
4. In the format options, you’ll see a “Custom” format option. Click on this, and you can then enter the desired date format.

For the Finnish date format “30.06.2024”, you can use the following custom format:

```auto
dd.MM.yyyy

```

After entering this custom format, the date in the subtitle should now be displayed in the desired Finnish format.

Alternatively, you can also use pre-defined date formats in Quick Sight. For the Finnish date format, you can select the “Finnish (Finland)” option from the “Locale” dropdown, and the date will be displayed in the correct format.

Remember that the date formatting options may vary depending on the version of Quick Sight you’re using, as Amazon may introduce new formatting options over time. Always check the available options in the latest version of Quick Sight.

---

<div class="post-metadata">

**Author:** ![Saurabh](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@Saurabh](https://community.amazonquick.com/u/Saurabh)\
**Post date:** [July 16, 2024, 5:19pm UTC](https://community.amazonquick.com/t/formatting-date-in-title-and-sub-title/32655/3 "2024-07-16T17:19:11Z")

</div>

> [@murili](#):
>
> Sight visual editor, locate the visual where you want

I am having below options when selecting subtitle

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/e/e/eea3960803620ac9b8b9fdcfcb079a39b9075421.png)

With finnish settings also it appeared same.  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/1/8/18c87579d324779c882bfacf231d4952c3defd93.png)

![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/8/b/8b09b8565e85de7cbcd85e7c17b16438fd3b4174.png)

---

<div class="post-metadata">

**Author:** ![murili](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/murili/32/21621_2.png) [@murili](https://community.amazonquick.com/u/murili)\
**Post date:** [July 16, 2024, 6:12pm UTC](https://community.amazonquick.com/t/formatting-date-in-title-and-sub-title/32655/4 "2024-07-16T18:12:09Z")

</div>

You can try moving the Visual to a paginated report sheet, and using a text box in the header with the desired print date format.

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [July 26, 2024, 4:22am UTC](https://community.amazonquick.com/t/formatting-date-in-title-and-sub-title/32655/5 "2024-07-26T04:22:13Z")

</div>

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community!