Unanswered

How to get date from Power FX

Like (1) Share

Report

Posted on 7 Oct 2024 19:58:24 by CU07101955-0

Hi I'm trying to take a date from a column called Start Date. It's formatted as MM/DD/YYYY. I’m trying to create a formula column where it takes the month and the day and changes the year to the current year. I’m having issues creating a formula column since Date isn’t supported. Anyone have any suggestions?

Categories:

Power Platform Build Tools

Power Apps component framework

All responses (2)

Answers (0)

WarrenBelz 146,947 Most Valuable Professional on 19 Oct 2024 at 00:42:41

Like (0)

Report

How to get date from Power FX

Just following up to see if you received the answer you needed, or if you require further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
WarrenBelz 146,947 Most Valuable Professional on 07 Oct 2024 at 20:53:52

Like (0)

Report
How to get date from Power FX

Hi CU07101955-0

I am not sure what you mean by Date isn't supported - firstly what is your Data Source ? If anything other than Excel (which you need to consider moving from ASAP), the formula would be
Date(Year(Today()), Month(YourDateField), Day(YourDateField))

If you trying to convert a string to a date
With( {_Date:Split(YourString,"/")}, Date(Year(Today()), Month(First(_Date).Value), Day(Index(_Date,2).Value)) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee