Date Box

[#1]

I Have a variable.

1. I want to select the variable from a date picker. How can i do this.

2. I want to check if variable is filled and bigger than other value.

Thx for helping me.

[Anonymous]

PFA

[#3]

? Please explain

[Anonymous]

In the attachment, vDate is the variable. The selected date in the calendar object is set to assign to this variable. So when you pick a date in the calendar object, vDate value changes to the selected date. using the calendar object, a user can select any date.

F2 is a column with dates from the data table. the text box displays yes/no based on whether or not the date picked in the calendar object (vDate value) is greater than a date value in the date column F2. So in other words, if the date selected in the calendar object is greater than a date in F2, it displays Yes, otherwise No.

This is just an example based on the information in your first post. You can modify it to suit your needs. Hope this helps.

[#5]

thx. But i have just license to open 1 file.

[Anonymous]

well, in that case, i will try to explain the steps:

1. click Ctrl+Alt+V to bring up the variables dialog box. click add and create a new variable say vDate. you can leave the value blank.

2. create a new calendar object (right click on the sheet and select slider/calendar and select calendar from the input style dropdown at the top)

3. in data section of the general tab, select radio button Variable. Then select vDate from the dropdown. remove any values in Max Value field below.

4. in Number tab of Slider/Calendar Object Properties, select Override Document Settings and select Date and input correct format pattern (for example, MM/DD/YYYY). this should match the date field format that you are going to compare it to.

5. pick a date from the calendar object and select a date from your date field (say F2).

6. comparison can be done using the expression vDate > F2...so your expression may look like

=if(vDate > F2, 'Future', 'Past')

i hope this helps.

[#7]

Thx very much. It helps.

But two questions.

First when i select a date from the calendar, i have big font. How to change this?

Second, is it possible to enter date from date picker or you simply enter date in format dd-mm-yyyy?

[Anonymous]

1.  In the calendar object properties (right click on the object and select properties), go to Font tab and change your settings there.

2. calendar object is not an input object so you cannot enter a date but only select it from the calendar.

[#9]

1. but when i do so, i see good font displayed in calendar box, but when select data in list of calendar box i see bold and another font

[Anonymous]

screenshot or a sample app should help clear this quickly.