Invalid Argument Type. Expecting a Number Value

[Anonymous]

Hi Team,

I'm working on a PowerApps form that has to compare a date with today's date. but I'm getting the error messages (attached). May I request you to help me out with that?

When I change the type from Text to Numbers though, no values are returned. I just got a blank in the field.

Thanks,

Shashanka

[timl]

Hi Shashanka

Assuming that TextInput3 is the text input control where you enter a date, instead of the condition that you're currently using (TextInput3 >Today()), the following formula should work without any errors.

DateTimeValue (TextInput3.Text,  "en-US") > Today

[v-monli-msft · Accepted solution]

Hi @Anonymous,

The formula should be:

DateTimeValue (TextInput3.Text,  "en-us") > Today()

"en-us" should be your local place. As Today() work with the local time of the current user.

Regards,

Mona

[Anonymous]

Hi timl,

Thank you for the quick response!

In this case, DatPicker1 is where a date is entered. TextInput1 is where a whole number is entered. This is added to the date in the DatePicker1 field. Textinput3 is where the date with the added days needs to be returned.

If the retuened date is greater than today, I need to have it highlighted.

Thanks again!

Shashanka 

[v-monli-msft · Accepted solution]

Hi @Anonymous,

I just tested with this formula and it works for me:

Notice that in TextInput3(mine is called TextInput2), the formula should be:

DateAdd(DatePicker1.SelectedDate,Value(TextInput1.Text))

Regards,

Mona

[Anonymous]

@v-monli-msft

Thanks for your help! It is working now.

-Shashanka