set analysis find date number of days before today's date

[fbi]

Hello everybody!

a question from a beginner;

I'm trying to write a set analysis that retreive  a price (Pris) based on the reseller (Återförsäljare) and date (Datum) where the date is number of days before today's date:

Example: today is the 3rd of march and I want to get the price having the date 27th february and reseller "Bygma"

this is what I wrote:

and here is how I dowload data:

thanks a lot in advance for all kind of help

[BrunPierre]

Hello, It seems that the format of your dates is not the same.

Datum={$(=Date(Today()-4, 'YYYY-MM-DD'))}

[Channa]

you can simply do this

=date(today()-4)

this will return MM/DD/YYYY

also check the data formate of this column "Datum" 

if "Datum" is not in MM/DD/YYYY then change it in load script

like Date(Date#(Datum,'YYYY-MM-DD'),'MM/DD/YYYY')

[Gabbar]

this would work if you correct the date format as mentioned in previous comments,

but is price  available for all dates or just when prices changes there is a entry like price changed on 1st feb and then on 1st march and you want price of 27th feb then the price of first feb is to be shown?

[fbi]

Hello thank you for your promt reply,

If I write the date format YYYY-MM-DD I get following error message

[tresesco · Accepted solution]

Try putting single quotes around date value like:

Datum={'$(....)'}

[fbi · Accepted solution]

sorry, this is the right print screen

[BrunPierre]

Similar to @tresesco's suggestion, but with double quotes.

Datum={"$(=Date(Today()-4, 'YYYY-MM-DD'))"}

[tresesco]

Of course, since the single quotes are already there with date formatting. Good catch.

[fbi]

Thank you very much, now it works! 😀