Unanswered

How to get date from Power FX

(1) Share

Report

Posted on 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 Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

Sort by

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No