Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I want to display today's Date in the text box in the format e.g. WEDNESDAY, 18th Feb 2015

I want to display today's Date in the text box in the format e.g. WEDNESDAY, 18th Feb 2015

Please help me out

1 Solution

Accepted Solutions
maxgro
MVP
MVP

good idea sunindia!

small change

=Date(Today(), 'WWWW, DD') &

     Pick(wildmatch(Day(Today()),

            1,21,31,

            2,22,

            3,23,

            '*'),

            'st ', 'st ', 'st ',

            'nd ', 'nd ',

            'rd ', 'rd ',

            'th '

    )

& Date(Today()+v, 'MMM YYYY')

View solution in original post

12 Replies
Anonymous
Not applicable
Author

You could use this in your text box:

=WeekDay(Today()) &', '&Date(Today(),'DD MMM YYYY')

You will also have to change your DayNames variable in the load script to this:

SET DayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';


sunny_talwar

Try this:

=Date(Today(), 'WWWWWW DD MMM YYYY')

Best,

S

sunny_talwar

Or another alternative:

=Date(Today(), 'WWWW, DD') & 'th ' & Date(Today(), 'MMM YYYY')

HTH

Best,

S

Anonymous
Not applicable
Author

Having 'th' will induce 1th, 2th, 3th, etc... You'll need more logic if you use that approach.

buzzy996
Master II
Master II

=Date(Today(), 'WWWW') &','& Date(Today(),'dd') &'th '& Date(Today(),'MMM YYYY')

sunny_talwar

Smart thinking Chris. I did not think about it.

I guess we can use a Match function to determine 'st' or 'th' or any other, may be.

Best,

S

sunny_talwar

My bad, not the match function, but the Pick function:

=Date(Today(), 'WWWW, DD') &

Pick(Day(Today()), 'st ', 'nd ', 'rd ',

                    'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ',

                    'st ', 'nd ', 'rd ',

                    'th ', 'th ', 'th ', 'th ', 'th ', 'th ', 'th ',

                    'st ')

& Date(Today(), 'MMM YYYY')

Best,

S

maxgro
MVP
MVP

good idea sunindia!

small change

=Date(Today(), 'WWWW, DD') &

     Pick(wildmatch(Day(Today()),

            1,21,31,

            2,22,

            3,23,

            '*'),

            'st ', 'st ', 'st ',

            'nd ', 'nd ',

            'rd ', 'rd ',

            'th '

    )

& Date(Today()+v, 'MMM YYYY')

sunny_talwar

Very nice. I like the collaboration we have went through within this post.

Thanks for proposing further simplification of the expression.

Best,

S