Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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