Compare Dates With Current Date

[barim]

Hello,

I would like to compare Projection_Date and Invoice Date to Current_Date, and if Projection Date and Invoice Date are less then Current Date it should be "I", other wise "A".

Thank you in advance.

 

[bborissov]

CASE WHEN Projection_Date < Current_Date THEN 'I' ELSE 'A' END

Borislav Borissov
VFP9 SP2, SQL Server

 

[Andrzejek]

barim,
Do you keep the [tt]Current_Date[/tt] as a field in your table? I hope not...
Then Borislav's code would be:

CASE WHEN Projection_Date < [blue]CAST(GETDATE() AS Date)[/blue] THEN 'I' ELSE 'A' END

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[barim]

Sorry for the late response, I really thank you for helping me. It works.