Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

undefined

Hi all, I have column of billing dates, i want to filter out the current financial dates from that column. Current financial year means april 2020 to march 2021. Please help me out. How i can...

Need Help

amitchandak
5 years ago
Anonymous ,

1. What exact output you want.

2. Why you do not a date table.

You can try a new column like this your table

New Column =
var _year = if(month(today())<=3, year(today())-1, year(today()))
var _st = date(_year,4,1)
var _end = eomonth(_st,11) //if need make 11 as 12
return
if(Table[Date] >= _st && Table[Date] <=_end , "This FY", "Other")
amitchandak
5 years ago
Anonymous , it is taken from 1-Apr-2020 to 31-Mar-2021

amitchandak

Super User

5 years ago

Anonymous ,

1. What exact output you want.

2. Why you do not a date table.

You can try a new column like this your table

New Column =
var _year = if(month(today())<=3, year(today())-1, year(today()))
var _st = date(_year,4,1)
var _end = eomonth(_st,11) //if need make 11 as 12
return
if(Table[Date] >= _st && Table[Date] <=_end , "This FY", "Other")

Anonymous

Not applicable

5 years ago

Thank you amitchandak . This solution worked for me.

Can you explain me that current financial year is taken as 2021 or 2020?

amitchandak
Super User
5 years ago
Anonymous , it is taken from 1-Apr-2020 to 31-Mar-2021
- Anonymous
  Not applicable
  5 years ago
  amitchandak Understood. Can you also tell what 11 in eomonth signifies?