web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps Convert Date to text a...

Power Apps - Building Power Apps

Suggested answer

Convert Date to text and Concatenate the field

(0) Share

Report

Report

Posted on by Prem4253

549

Hello,

I've a Period Date field within PowerApps form. I need to convert Period Date to a text string into a text field

For e.g. If selected date is 01-Apr-2023, the text field will covert/show 0423 (this is presently what is calculated in Excel)

Once date is converted to text, I'll need to have a concatenate of Date Converted to text and Rolling No (which is 0423T32MCSC) - see above image.

Please advise. Thanks!

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Pacel1 79 on at

Like (0)

Report
Convert Date to text and Concatenate the field

I was made an example for You :)

Code for Convert date time
Text(DateTimeValue(DatePickerCanvas1.SelectedDate),"mmyy")
Code for Concatenate
Concatenate(Text(DateTimeValue(DatePickerCanvas1.SelectedDate),"mmyy"),TextCanvas3_3.Text)

If you found my response helpful, feel free to mark it as the solution or give it a thumbs-up!

Was this reply helpful? Yes No
Prem4253 549 on at

Like (0)

Report

Convert Date to text and Concatenate the field

@Pacel1

Thanks! this did the trick. Working as Expected.

Was this reply helpful? Yes No

Join the conversation