Date Functions

[Dave Smith]

I've been having problems with my dates
Could you please help with my date queries?

Day functions are not working. "Pulling the correct information"

Monday
Date()-((((Weekday(Dat e()+2))+3)))

Tuesday
Date()-((Weekday(Date( ),2))+5)

Wednesday
Date()-(Weekday(Date() ,2)+4)

Thursday
Date()-(Weekday(Date() +2)+0)))

Friday
Date()-(Weekday(Date() +2)+6)

Month to Date
Format(Date()," yyyymm")

----------------------------------------------------

Other examples

PreMonth
(((DateDiff("m" ,[DateofPayment],Date()))=1))

PreYear
Expr1: DateDiff("yyyy" ,[DateofPayment],Date())

Today
DateAdd("d",0,D ate())

Year to Date
Format(Date()," yyyy")

ONe Month Back
(((DateDiff("m" ,[DateofPayment],Date()))=0))

Two Months Back
(((DateDiff("m" ,[DateofPayment],Date()))=1))

[Narender Sagar]

Have you checked your system date format in control panel.

[jforbes]

I don't quite understand what you are having trouble with. I can see a lot of things that don't quite look right, but it would be helpful if you narrowed it down with a little more information on what is not working for you. Like a specific function, the results you got and what you expected to happen.

[NeoPa]

Please rephrase your question clearly. This is very basic and doesn't make even your requirements clear.