Creating an expression to include <Todays Date + 547 days> selection

[#1]

Some advice please,

In my Data Load Editor, I create a count which includes    " [SALES.CLOSEDATE]={">=20/07/2017<20/01/2019"}, " ( for example )  to select those records present from the day I re-fresh the data, to include the data for the next 547 days ( 18 months of Pipeline data ), but at the moment I'm having to create this by changing the date parameters.

I've tried:    " ={'MonthStart(Today(), 1)'} " adding the 547 days within this string, but I'd like to automate the running sequence and having something will take the date it is run + 547 days, will help me do this.

Any suggestions please ?

Thank you

( I'm back on line on Tuesday 25th so will pick up those suggestions then )

[neelamsaroha157]

Create two variables as

Let vTodaydate = Today();

Let vNextDate = Date(Today()+547, 'DateFormatHere')

OR

Let vNextDate = Date(AddMonths(Today(), 18), 'DateFormatHere') --If you looking for exact 18 months.

[jonathandienst]

Something like

[SALES.CLOSEDATE] = {">=($=Today()) <$(=(Today() + 547))"}

or

[SALES.CLOSEDATE] = {">=($=MonthStart(Today())) <$(=MonthEnd(Today() + 547))"}

or

[SALES.CLOSEDATE] = {">=($=MonthStart(Today())) <$(=MonthEnd(Today(), 18))"}

[#4]

Hi,

Thank you for your advice.

Barry

[#5]

Hi,

Thank you for your advice.

Barry