You’re offline. This is a read only version of the page.
2
Hi,
I have a standard date column named "MyDate"
I want to create a custom column with year + quarter number, like: 2023 Q1
If I use this, it is working well: Date.Year([MyDate]) I am getting year number in my "MyQuarter" column
this is also fine: Date.QuarterOfYear([MyDate]) again I am getting quarter number in my "MyQuarter" column
but the combination not:
Date.Year([MyDate]) & " Q" & Date.QuarterOfYear([MyDate])
where I am doing a mistake
Thank you for your help
Share
Report
All responses (
Answers (
