SQL：明年的过滤条件 [英] SQL: Filter condition for Next year

问题描述

Hello Everyone - 我在下面的查询中得到了不应该选择IgnoreAssistanceInactivityAutoClose = 1和  ResetDateForIgnoreAssistanceInactivityAC ='Nextyear-04-30 00：00：00.000'的应用程序。


在这种情况下，突出显示的应用程序已经"2020-04-30 00：00：00.000"，明年它将是"2021-04-30 00：00：00.000" 。 

因此，我不想硬编码，它应该通过变量或参数自动进行。 
$


我认为它应该是条件的一部分。 

Hello Everyone - I got this below query where I shouldn't pick Application whose IgnoreAssistanceInactivityAutoClose =1 and ResetDateForIgnoreAssistanceInactivityAC = 'Nextyear-04-30 00:00:00.000'.
In this case the highlighted Application has got '2020-04-30 00:00:00.000', Next year it will be '2021-04-30 00:00:00.000'. 
So, I don't want to hard code it, it should be automatically through variable or parameters. 

I think it should be some where condition. 

	Select distinct vwpa.PatientId, vwpa.ProgramId, Vwpa.ApplicationId, AssistanceTypeId, vwpa.StatusDate, isnull(pd.InvoiceDate,0),
			DATEDIFF(day, isnull(pd.InvoiceDate, 0), Getdate()) Inactivedays,
			DATEDIFF(day,  isnull(vwpa.StatusDate,0),Getdate()) Inactivedays_Status,
			ApplicationStatusreasonId, app.IgnoreAssistanceInactivityAutoClose, app.ResetDateForIgnoreAssistanceInactivityAC
		From dbo.vwPatientApplicationStatusCurrent vwpa
			Inner Join program prg				On vwpa.ProgramId = prg.ProgramId   
			Left Join [Application] app			On vwpa.ApplicationId = app.ApplicationId  
			Left Join PatientDistribution pd	On vwpa.ApplicationId = pd.ApplicationId 
												and vwpa.PatientId = pd.PatientId 	
												and pd.InvoiceDate =	( 
																		Select max(InvoiceDate) 
																		From PatientDistribution pd1 
																		Where vwpa.ApplicationId = pd1.ApplicationId 
																			and vwpa.PatientId = pd1.PatientId
																		) 

		Where ApplicationStatusId = 1    
		and AssistanceTypeId not in (2) --copay
		and prg.AssistanceInactivityAutoCloseIndicator = 1  --Program level Indicator
		and app.InactiveDateTime is null
		and app.SoftDeleteDateTime is null
		and vwpa.patientid = 118626

推荐答案

convert（char（4），year（sysdatetime（））+ 1）+'0430'

convert(char(4), year(sysdatetime()) + 1) + '0430'

这篇关于SQL：明年的过滤条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！