Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi KArathorn,
thanks for your help.
At last, I need a expression with a MakeDate() function.
greetings
Sven