Formula error

[patty1]

Why do I get "not enough arguments have been given to this function."? This formula is in Select Expert.




Date({sp_WTD_MTD_YTD_AllProducts.Post_Date}) in
Date(Year({?@EndDate}),Month({?@EndDate}),01) to {?@EndDate}

 

[mbarron]

If this field {sp_WTD_MTD_YTD_AllProducts.Post_Date} is a date field, you don't need the Date( ).

The Date( ) is used to create the date as you have in this part of your formula:
Date(Year({?@EndDate}),Month({?@EndDate}),01) Mike
If you're not part of the solution, you're part of the precipitate.

 

[patty1]

Am now getting "too many arguements given to this function" with the cursor going to the begining of Month. Have tried moving around parens but no good. AACCKK!


{sp_WTD_MTD_YTD_AllProducts.Post_Date} in
Year({?@EndDate},Month({?@EndDate},01) to {?@EndDate} )

 

[mbarron]

Your formula should look like this:

{sp_WTD_MTD_YTD_AllProducts.Post_Date} in
Date(Year({?@EndDate}),Month({?@EndDate}),01) to {?@EndDate} Mike
If you're not part of the solution, you're part of the precipitate.