Lookup function doesn't return dates

[TomaszCPL]

Hi,

I do have quite a strange problem. I've got this varProjectFound, which stores a record retrieved from my SQL database. 

Set(varProjectFound, LookUp('[app].[Project]',ProjectName=DataCardValue8.Text));

I want to be able to check whether a currently selected date value matches the one previously stored in the database. 

varProjectFound.ProjectEndDate <> dtProjectEndDate.SelectedDate

However, I am not able to do it since the varProjectFound.ProjectEndDate is always empty. The same applies to my other date fields. Other properties of the varProjectFound record are correct, eq I am able to call varProjectFound.ProjectName, and get the right value.

Is this a limitation or would it rather be a bug within my power app?

Thank you

[StalinPonnusamy]

Hi @TomaszCPL

I tested both (Lookup and Date Validation is correct) and works fine. 

• Can you check any delegation warning on this command? (= should work)
• Can you check what value getting from DataCardValue8.Text?
• Hard cord the value to see whether a specific item exist in DB or not

Test Made both works fine

Set(
    varProjectFound,
    LookUp(
        DimProduct,
        ProductAlternateKey = "AR-5381"
    )
);

varProjectFound.StartDate = DatePicker1.SelectedDate

[WarrenBelz]

@TomaszCPL ,

Just adding some input here - have you tried View>Variables>varProjectFound and looked at what is in ProjectEndDate? Also are you running this code on the OnChange of DataCardValue8 ?

The other matter - be careful with dates and <>. I suggest

Abs(
   DateDiff(
      varProjectFound.ProjectEndDate,
      dtProjectEndDate.SelectedDate,
      Days
   )
)>0

[TomaszCPL · Accepted solution]

Thank you, although what's the issue with using the <> comparison?

Looks like it was just a bug, it started to work correctly today >.< 

[WarrenBelz]

@TomaszCPL .

I have found it inconsistent with Dates (as well as equals at times) as dates are stored including time and have always used the DateDiff(Days), which always works.