Replace Today and Yesterday with correct dates

[PPStar]

Hello. 

I am grabbing data into a CSV file on a daily basis. 

The date column that i want to create a relationship with my date table is coming through like ths

How can i get Power Query to automatcally turn Today into Todays date and Yesterday into Yesterdays date? - We can remove time for now, as i just want to relate ton the date. 

Thanks for any tips

[MFelix]

Hi @PPStar ,

If you are getting the files from a folder just keep the column Date created or date modified after doing the function call then use a conditional column like this:

if  Text.Contains ([Star time] , "Today" ) then [Date created] else 
if  Text.Contains ([Star time] , "Yesterday" ) then 
[Date created] - #duration(1,0,0,0)
else 
[Start Time]

this may need to be adjusted.

[PPStar]

The files will be manually dropped into a folder on a daily basis.  

The Date Created column is not part of the table.. Where do i get that from. 

Can i not juts change the [Date Created] to Now()  or something similar?

[MFelix · Accepted solution]

How are you getting the files is it based on the Folder?

If yes you need to go to remove the step remove other columns, then add the new column based on the creation date and after that delete all the columns that are related with the folder: