Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make a date to textbox for a month

Hello erverybody.

I need your help.

I have text boxes 32nd. In each textbox the date of a day must be to a selected month.

How can I make a formula to each texbox to say that this is the appointed day for this textbox.

In every textbox must be one date of month.

For example:

First textbox = first day of the month; secend textbox = secend day of the month etc.

What can I do?


I think I need the date in the text box to this table with a link to be entered in the data, which are linked to the text boxes with the corresponding date.

2 Replies
Not applicable
Author

Hi,

In this example U have to select only one Year and only one Month.

=Year & '-' & If(Num(Month) < 10, 0) & Num(Month) & '-' & '01'

The Num(Month) gives U the number of the month

The If(Num(Month) < 10, 0) adds a 0 the result if month if 9 or lower

For each box U will have to add the last two digits by your self, like 01, 02, 03 etc...

The result will look like this 2013-06-07

Brg//KArathorn

Not applicable
Author

Hi KArathorn,

thanks for your help.

At last, I need a expression with a MakeDate() function.

greetings

Sven