Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi community,
Would you please give me advice what is the best way to extract the date from this specific timespamp:
P2019Y3M11DT11H4M54S
I've tried to use MID function to exctract the parts and concatenate them by ".":
Date =
Solved! Go to Solution.
Hey,
I would do something like this:
DATE( VALUE(< something that returns the year >) ,VALUE(< something that returns the month >) ,VALUE(< something that returns the day >) )
Regards,
Tom
Thank you guys, now it works!
Hey,
I would do something like this:
DATE( VALUE(< something that returns the year >) ,VALUE(< something that returns the month >) ,VALUE(< something that returns the day >) )
Regards,
Tom
Hi Egor,
test:=date(mid("P2019Y3M11DT11H4M54S",find("P","P2019Y3M11DT11H4M54S")+1,4),mid("P2019Y3M11DT11H4M54S",find("M","P2019Y3M11DT11H4M54S")+1,2),mid("P2019Y3M11DT11H4M54S",find("Y","P2019Y3M11DT11H4M54S")+1,1))
Probably not the best way, but this works.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |