I am looking for help on creating an if date between Jan and March then return 1 value to autofill quarterly text value field.
Any help is greatly appreciated.
Thank you!
Solved! Go to Solution.
Hi @TKSHEP
One way to approach this would be to use the format-date() function to get the month as a number. You can then use something like if(${my_month}<=3, 'Q1', 'Q3 - Q4') to return the value you want. For example:
For more on date formatting, see the Formulas topic in the documentation.
Hope this helps, Jim
Hi @TKSHEP
One way to approach this would be to use the format-date() function to get the month as a number. You can then use something like if(${my_month}<=3, 'Q1', 'Q3 - Q4') to return the value you want. For example:
For more on date formatting, see the Formulas topic in the documentation.
Hope this helps, Jim