Answered

Convert Text to date

(0) Share

Report

Posted on by Connor_Taylor

143

Hello,

Simple problem, can't find a solution
I have a text-input in the format of "text" and looks as such:

And I need to patch it to my SQL database that has the format "date" as such:

How can I convert the text input in that format to date the same as the sql format.

thanks for any help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-monli-msft Microsoft Employee on at

Like (6)

Report
Copy link

Link copied!
Hi @Connor_Taylor,

Try to use:

Text(DateTimeValue(TextInput1.Text), "yyyy-mm-dd")

TextInput1 is the textinput control name.

Regards,

Mona

Was this reply helpful? Yes No
Connor_Taylor 143 on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-monli-msft

Was this reply helpful? Yes No
PytByt 943 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-monli-msft

@v-monli-msft wrote:
Hi @Connor_Taylor,

Try to use:
Text(DateTimeValue(TextInput1.Text), "yyyy-mm-dd")
TextInput1 is the textinput control name.

I'm trying to implement your formula in a made up label, but i get this anomaly:

Also:

I'm hoping to get the 22/02/28 or 22-02-28

What went wrong?

Thanks,
pytbyt

Was this reply helpful? Yes No