topic Re: Formatting a Dynamic Window Title to use a specific date format in QlikView

Formatting a Dynamic Window Title to use a specific date format

Tue, 21 Apr 2015 16:38:10 GMT

Trying to configure a window title to dynamically render the date in a MM/DD/YYYY format, but still displaying the numeric value for the date. I'm using the following expression that works for another window:

=max([POS Date]) & 'Position Data Details-On-Demand'

Any thoughts on what I need to do to get the date to display 12/31/2014?

Re: Formatting a Dynamic Window Title to use a specific date format

buzzy996 — Tue, 21 Apr 2015 16:42:33 GMT

try this,

=max(date#([POS Date],'MM/DD/YYYY') & 'Position Data Details-On-Demand'

Re: Formatting a Dynamic Window Title to use a specific date format

Tue, 21 Apr 2015 16:45:45 GMT

Shiva,

Thank you. That worked.