DateAdd: add a formula to the number argument

[epardo87]

Hello,



in a query I i'm trying to pull a number from a combobox in a formula so that it populates the "number" argument inside the DateAdd function, but I'm not having any success...

this is inside the expression builder...

Between Now() And DateAdd("ww",[forms]![frm80Expiring]![lstWeeks],Now())

I already tested the formula replacing the [forms]![frm80Expiring]![lstWeeks] by a simple number and it works as required, I just need to be able to select how many weeks to add to the filter...

what am I doing wrong?

[Bulzie]

That syntax should work, I tested with same and it worked. Is the combo box weeks value based off of a table or did you type the values in? Are you sure your records have a date within that range?

[epardo87]

That syntax should work, I tested with same and it worked. Is the combo box weeks value based off of a table or did you type the values in? Are you sure your records have a date within that range?

Thanks, I typed the values inside the listbox and yes, I'm testing with 20 weeks, when I typed the furmula writing the number 20, it did filtered correctly...
I don't know if something in the parameters of the listbox (Event is empty):

[Bulzie]

Test that you are getting the right value from the list box. select a value from the list, then In a query, try: x: [forms]![frm80Expiring]![lstWeeks]

and see if the value matches what you selected in the listbox.

Another idea is to create a new list box, substitute the name in your query and see if it works.

[pbaldy]

A shot in the dark, to make sure the value is seen as a number:

DateAdd("ww",CInt([forms]![frm80Expiring]![lstWeeks]),Now())

[epardo87]

A shot in the dark, to make sure the value is seen as a number:

DateAdd("ww",CInt([forms]![frm80Expiring]![lstWeeks]),Now())

thanks for your advice, I tested it and had no success using the same formulas

Test that you are getting the right value from the list box. select a value from the list, then In a query, try: x: [forms]![frm80Expiring]![lstWeeks]

and see if the value matches what you selected in the listbox.

Another idea is to create a new list box, substitute the name in your query and see if it works.

I did this and it retrieved me 0, what I did was to test several ideas in this column and what did the trick is to change the listbox to a combobox, I wanted to use the listbox so that the user could select the number of weeks using the up or down arrows, but I rather have it working regardless of the combobox...

giving it a second thought, now I get it, when I use the arrows in the listbox, I left the number in display but it was never selected, that is why it retrieved me 0!! how fool am I!
look at the form so that you see the issue (the first one is already a combobox, but the second one is a listbox with a number in display, but not selected) :


Thanks for your help!