cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ianallen13
Helper IV
Helper IV

change date value for concatenation

Hello, 

 

Hoping someone here can provide some guidance for this issue.  

I have a field that literally just has 'Today()' for todays date and I want it formatted as 8182022 instead of 8/18/2022.  When I change the format, I can do this, but I what this simplified format to also be used in concatenation with another field (basically getting rid of the /) and I cannot get that to work.

 

So basically got this figured out.

ianallen13_0-1660841542681.png

 

But when I concatenate that value with another in a separate field to create a 'special ID' for that record - I want the slashes gone - and not sure how.

ianallen13_1-1660841592364.png

 

Anyone have any simple fix ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
NuttyPistons
Responsive Resident
Responsive Resident

Hi @ianallen13 ,

Try this code:

Concatenate("1234567", Text(Today(),"mddyyyy"))

View solution in original post

3 REPLIES 3
NuttyPistons
Responsive Resident
Responsive Resident

Hi @ianallen13 ,

Try this code:

Concatenate("1234567", Text(Today(),"mddyyyy"))

NandiniBhagya20
Solution Sage
Solution Sage

Hi, 
You can use below formula - 

Concat(Split("12/444/55","/"), Result, "")
Instead of text ("12/444/55") you can use your concatenated text.


Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

ianallen13
Helper IV
Helper IV

That worked perfectly!  TYSM!!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,788)