I want to create a title with formatting of parameter. My parameter’s datatype is Datetime. Title should ending with Month and year(‘MMM-YY’) of my parameter.
Please let me know if there is any way to use formatDate function with parameter.
@JoseB-aws - did you see the responses here - formatDate does not (seem to) work in titles, you can only use text or parameters.
We have a similar problem; we want to use a date parameter in a title to make clear that the data has been filtered on that date, but you cannot format the parameter and by default a date comes out YYYY-MM-DD, which is confusing for users, particularly since this is a monthly report and everywhere else we’re just talking about the month. Formatting as MMM-YY would solve this, but from the last couple of hours of digging I just don’t think it’s possible?
Hello, @lillie!
I’d just like to help build momentum for this request. I have not been able to use formatDate, or any other expression, in order to format a Datetime parameter inside of a Title/Sub-title. As far as I can tell, the only available format is the default (YYYY-MM-DD).
Thank you for looking into this, Quicksight Team
Nick
@Neeraj - I am in a similar boat to @JRK and @NickA as I would like to display the datetime Parameter but formatted version of the value instead of the default.
I realize this question is closed, but can we suggest this as a QS feature request? Being able to apply formula functions to parameters within the Title and Subtitles Edit interface?
Below is an example of my attempt to edit the parameter and apply a function to just display the month of the selected parameter value.
I also agree to @bkasen. The default format YYYY-MM-DD is too restrictive. Can we add this as a feature request? I also need to apply a formatDate to the parameter in visual titles. However it is not possible and saw this query in community.