@RandyHayes
Hello,
I have something kind of off happening with a Due Date label that I'm having a hard time troubleshooting. I'm wondering if it has anything to do with the fact that it is a calculated column. Doesn't seem like that should be a factor, but it is the only thing I have done differently than usual with a date column so I figured I would add the details below.
Here is the formula I am using to calculate due dates in my Onboarding tasks SharePoint list based on the person's start date and when the task is due (e.g. by their start date, the first week, the first month, etc.).
Both the start date and due date are showing up in a friendly format as expected in the SharePoint list and the due dates are calculating correctly. An example of Day 2 of week one is shown below.
My original label formula was originally just ThisItem.'Due Date', but when that didn't work I tried the following formula which as you can see from the first screenshot didn't work either.
Text(ThisItem.'Due Date', "mm-dd-yyyy")
I created a workflow that sends a table of tasks to the task owner that includes the due dates. I'm able to successfully define how the date should look there so I don't know why I can't seem to make it happen in Power Apps. I believe my syntax is correct, it seems to follow along with advice you gave on this post (they were looking for a different day/month order, but the idea is the same:
Solved: Re: Date format in labels and datacard - Power Platform Community (microsoft.com)
Any idea why I can't make my Due Date label behave?
Kind regards,
Teresa
