cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yichingjc
Level: Powered On

Convert dropdown value from dd/mm//yyyy to Month and Year

I have a dropdown that has filter formula: Filter('Pay Summaries', rr_Resource.name = pro.Name) and the value is set startdate (format mm/dd/yyyy).  I wanted to convert it to Month and Year instead. Is it possible? 

yichingjc_0-1572374684548.png

1 ACCEPTED SOLUTION

Accepted Solutions
yichingjc
Level: Powered On

Re: Convert dropdown value from dd/mm//yyyy to Month and Year

I figured it out. Text('Start Date',"[$-en-US]mmm") & " " & Text('Start Date',"[$-en-US]yyyy")

View solution in original post

9 REPLIES 9
cds
Level 8

Re: Convert dropdown value from dd/mm//yyyy to Month and Year

Text(Startdate, "mm/yyyy")

yichingjc
Level: Powered On

Re: Convert dropdown value from dd/mm//yyyy to Month and Year

@cds that didn't work. see below. 

yichingjc_1-1572375146424.png


yichingjc_0-1572375094420.png

cds
Level 8

Re: Convert dropdown value from dd/mm//yyyy to Month and Year

Text(Filter('Pay Summaries', rr_Resource.name = pro.Name).ColumnName, "mm/yyyy")

yichingjc
Level: Powered On

Re: Convert dropdown value from dd/mm//yyyy to Month and Year

@cds I tried Text(Filter('Pay Summaries', rr_Resource.name = pro.Name).rr_startdate, "mm/yyyy") but it didn't work.  It gave me the same error. 

cds
Level 8

Re: Convert dropdown value from dd/mm//yyyy to Month and Year

and you are in the Items property ?

yichingjc
Level: Powered On

Re: Convert dropdown value from dd/mm//yyyy to Month and Year

@cds Yes. 

cds
Level 8

Re: Convert dropdown value from dd/mm//yyyy to Month and Year

what is the error when you hover over the filter part of the formula

yichingjc
Level: Powered On

Re: Convert dropdown value from dd/mm//yyyy to Month and Year

@cds This is the error. 

yichingjc_0-1572378402362.png

yichingjc
Level: Powered On

Re: Convert dropdown value from dd/mm//yyyy to Month and Year

I figured it out. Text('Start Date',"[$-en-US]mmm") & " " & Text('Start Date',"[$-en-US]yyyy")

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (6,005)