You’re offline. This is a read only version of the page.
Announcements
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
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.
Share
Report
All responses (
Answers (
36,411
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"))
