DLookup !type error or blank

[gmazza76]

Good morning

I am trying to update a date from my "LoadDates" table into my from LandingPage userform.
The LoadDates table only has 2 fields "From Date & To Date" but I could do with the date being visible.

Currently the formula below gives a blank but should in this instance show yesterdays date.
I think its something simple but I have been going round in circles with this one.

=DLookUp("[LoadDates]![From Date]","LoadDates","[LoadDates]![From Date]"=" & [Forms]![LandingPage]![Text45] & ")

thanks in advance

 

[Anbuselvam]

=DLookup("[From Date]","LoadDates","[From Date]=#" & Date()-1 & "#")

 

[gmazza76]

=DLookup("[From Date]","LoadDates","[From Date]=#" & Date()-1 & "#")

thank you @Anbuselvam