Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Custom Column - combine two query function

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

3 Replies