Unanswered

I keep getting a weird error with Text() Function

(0) Share

Report

Posted on by Community Power Pla...

Hi, I am currently trying to use the Text() function to turn a Date (today) into a string in a yyyymmdd format. I currently have:

Text(Today();"yyyymmdd")

My problem is, whenever I try to type that, it autofills into something weird: Text(Today();"[$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419][$-es-419]yyyymmdd")

I don't know what it keeps doing that, whenever I try to leave it alone after typing my function, it turns into that. Seems like areally weird bug.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

SeanHenderson 1,104 on at

Like (0)

Report

Hi @Anonymous
You should use a , instead of a ;
Text(Today(),"yyyymmdd")
---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous

PowerApps adds the format according to the settings configured as per your account.

Can you try to use the below expressions and check if any of them works:

Text(Today();"[$-es-419]yyyymmdd")
Text(Today(),"[$-es-419]yyyymmdd")

Also, regarding using ; or , -> this depends on the regional settings of the PowerApps studio.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Since I'm using a localized version, using "," instead of ";" gives me an error.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous

Have you tried, using Text(Today();"[$-es-419]yyyymmdd")

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No