100
200
300
400
500
600
200
100
250
200
1000
100
700
200
300
500
500
600
Formula
Using DateTimeNow() - Filter last month of previous quarter
Using DateTimeNow() - Filter last month of previous quarter
300
250
300
Desired output - last month of previous quarter
Desired output
C:\Users\Philip\AppData\Local\Temp\Engine_17712_e2fad5d2fe5ac749bd0ed82db68fe03e_\Engine_17712_9f40f436e6924a44aec8c608abf0e208~.yxdb
Single
Profile
C:\Users\Philip\AppData\Local\Temp\Engine_17712_e2fad5d2fe5ac749bd0ed82db68fe03e_\Engine_17712_1a54080fc1bc6747a7ab298b08e9b8f9~.yxdb
Single
Profile
1
date = datetimeadd('2022-01-01', [RowCount], 'month')
quarter = floor(mod(tonumb...
Field1
RowCount
Int32
4
0
RowCount <= 15
RowCount + 1
Formula
startswith([name], tostring(
if datetimemonth(datetimetoday()) < 4 then datetimeyear(datetimetoday()) - 1 else datetimeyear(datetimetoday()) endif // year
) + '-' +
padleft(
tostring(
(floor(mod(tonumber(datetimemonth(datetimeadd(datetimetoday(), -4, 'month'))), 12) / 3) + 1) // previous quarter
* 3 // last month
), 2, '0'))
C:\Users\Philip\AppData\Local\Temp\Engine_17712_e2fad5d2fe5ac749bd0ed82db68fe03e_\Engine_17712_fb1f1599e320d4488768a77cf1dd81c8~.yxdb
Single
Profile
Horizontal
last-month-previous-quarter