Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 )
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.
Something like
[SALES.CLOSEDATE] = {">=($=Today()) <$(=(Today() + 547))"}
or
[SALES.CLOSEDATE] = {">=($=MonthStart(Today())) <$(=MonthEnd(Today() + 547))"}
or
[SALES.CLOSEDATE] = {">=($=MonthStart(Today())) <$(=MonthEnd(Today(), 18))"}
Hi,
Thank you for your advice.
Barry
Hi,
Thank you for your advice.
Barry