-
1. Re: Date Filter Format
Emre Mustafa GÖKCAN Feb 7, 2018 2:12 AM (in response to Cihangir Özçelik)Hi Cihangir,
You can solve by creating 3 calculation fields.
You can solve it by adding the x calculation(3) filter from the calculated fields.
step by step ;
1-) first day of the week = DATE(DATETRUNC('week',[DATEFIELD]))
2-)last day of the week = DATE(DATEADD('day',-1, DATEADD('week', 1, DATETRUNC('week',[DATEFIELD]))))
3-)[X CALCULATION] =STR(YEAR([DATEFIELD]))+' '+ STR(DATEPART('week',[DATEFIELD])) +'.week ('+ STR([first day of the week])+ '/'+STR([las day of the week])+')'
-
2. Re: Date Filter Format
Ruchika R Feb 7, 2018 2:18 AM (in response to Cihangir Özçelik)2 of 2 people found this helpfulHi,
Check if this helps.
Formula -
STR(Year(Today()))+' '+STR(DATEPART('day', Today()))
+'.Week('+
STR(DATEPART('day',(Datetrunc('week',today())+1)))+'.'+
STR(DATEPART('month',(Datetrunc('week',today())+1)))+'.'+
STR(DATEPART('year',Datetrunc('week',today())+1))
+' - '+
STR(DATEPART('day',(Datetrunc('week',today())+7)))+'.'+
STR(DATEPART('month',(Datetrunc('week',today())+7)))+'.'+
STR(DATEPART('year',Datetrunc('week',today())+7))
+')'
Regards,
Ruchika