Query to get 1st day of the succeeding month

[wiz_traceremo]

Hi,

I'm attempting to create a query to retrieve the first day of the following month. I intend to use this query as FMS in the Posting Date field under Sales Quotation, but I'm encountering an error.

---------

SELECT

DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE()), 0) AS FirstDayOfSucceedingMonth

---------

Thank you.

[LoHa]

Hi Taira,

it works fine for me. Which error do you receive?

Is it possible, that you did not activated the new periods for next year?

regards Lothar