Hi Everyone.
I have a birthday column with values like below where first two digits are date(dd) and last two are months(mm)
2411
0908
2211
....
.....
what is the best way to achieve a date format(mm/dd/yyyy) out of these values.
Also the YYYY value should be automated. it should reflect the current year.
Solved! Go to Solution.
Hello Partha,
An example to use as a reference:
Button1.OnSelect= ClearCollect(ColBirthday,1111,2202,3103,1305)
Gallery1.Items = AddColumns(ColBirthday,"Date",Left(Text(Value),2)&"-"&Right(Text(Value),2)&"-"&Year(Today()))
You can add two labels in the gallery and if you set Label1.Text = ThisItem.Date, you can see the date you have asked for.
Hello Partha,
An example to use as a reference:
Button1.OnSelect= ClearCollect(ColBirthday,1111,2202,3103,1305)
Gallery1.Items = AddColumns(ColBirthday,"Date",Left(Text(Value),2)&"-"&Right(Text(Value),2)&"-"&Year(Today()))
You can add two labels in the gallery and if you set Label1.Text = ThisItem.Date, you can see the date you have asked for.
thanks.. i got this working
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
199 | |
97 | |
57 | |
51 | |
42 |
User | Count |
---|---|
264 | |
157 | |
83 | |
79 | |
57 |