Lantica User Forum - Program Retrive Spec for the last six months,

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Program Retrive Spec for the last six months,

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Program Retrive Spec for the last six months, (Read 324 times)

drastixnz Full Member Offline A Newbie.... Posts: 146 Location: New Zealand Joined: Nov 29^th, 2006	Program Retrive Spec for the last six months, Sep 6^th, 2007 at 2:51am	Print Post
	Hi all, I have this, and i know it is o so wrong, it works for last month but no matter I cant get it working for the last six months, { @Left(Date Completed, 7) = @Left(@Date - @Dom(@Date), 7) } What have i done wrong Drastixnz


	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Program Retrive Spec for the last six months, Reply #1 - Sep 6^th, 2007 at 3:03am	Print Post
	1 year = 365.25 days 6 months = .5 yrs = 182.625 days Completed in the Last 6 Months = {DateCompleted >= @Date - 182.625}

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›