Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am working on a functionality where I need to add a default selection based on the month we are in to a period field which has values like 2021 Q1, 2021 Q2, 2021Q3, 2021 Q4 and others
As we are in Aug so the field should get selected with "2021 Q3" automatically when the user log in. Below is the expression am using but its not working
[Field Period] = {$(=Year(today()) &'Q' & Ceil(Month(today())/3))} - the filed name has a space in it and cannot be changed
Have tried using the expression in a variable and using the variable like below -
Any help on this will be greatly appreciated!
thanks in advance
I am able to achieve the desired result using concat function, refer below expression -
"=[Field Period]=Concat(Year(today())&' Q'&Ceil(Month(today())/3),' ')"
This is working as expected and have added this is bookmark which will allow the latest period selection when user lands on the screen
Hi @punitpopli ,
First I suggest you to search for your expression in the field to check if it is correct or not.
Then I'd create a bookmark for it.
Best Regards
Thank you for your response. I did validated it and was not working as expected.
Hence posted the expression in the forum
I am able to achieve the desired result using concat function, refer below expression -
"=[Field Period]=Concat(Year(today())&' Q'&Ceil(Month(today())/3),' ')"
This is working as expected and have added this is bookmark which will allow the latest period selection when user lands on the screen