web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Month Name Issue

Power Apps

Unanswered

Month Name Issue

(0) Share

Report

Report

Posted on by abhoria

Hi Team,

I am working on a PowerApps where I am using one formula to create Month name(MMM'YY) based on Fiscal calendar given by Client. For all users our formula is working correctly except for two users. It was working fine till the last month. Below is the formula :

If(Lookup(FiscalCloseCal,'Month End Close' = Text(Today()-Day(Today()),"[$-en-US]mmmm") And 'Fiscal Year' = Year(Today()-Day(Today())),'Actual Due') < Today(),Text(Today(),"[$-en-US]mmm'yy"),Text(Today()-Day(Today()),"[$-en-US]mmm'yy"))

FiscalCloseCal is referring to the attached screenshot.

Attaching one screenshot for showing wrong month output.

FYI, every user is using this Powerapp from different Time Zone.

Any help is much appreciated.

Thankyou

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

timl 37,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@abhoria

In the final section of your formula where you call Text, if you pass an English language code (en-US), that should hopefully resolve the problem.

If(Lookup(FiscalCloseCal,'Month End Close' = Text(Today()-Day(Today()),"[$-en-US]mmmm") And 'Fiscal Year' = Year(Today()-Day(Today())),'Actual Due') < Today(),Text(Today(),"[$-en-US]mmm'yy"),Text(Today()-Day(Today()),"[$-en-US]mmm'yy", "en-US"))

Was this reply helpful? Yes No

Join the conversation