CODEWITHSUNDEEP
crystal-reportscrystal-reports-xi
OVO
OVO

Reputation: 123

how to pull data that is older than 6 months on Crystal Report XI?

I have a field titled COMPLTDATE that is a DATETIME; however when I write,within select expert, {ORDERSEC.COMPLTDATE} >= currentdate - 6 months I receive an error.

How should I write it so that it pulls all the data from the last six months ?

Upvotes: 0

Views: 1599

Answers (1)

CoSpringsGuy
CoSpringsGuy

Reputation: 1645

{ORDERSEC.COMPLTDATE} >= DateAdd ('m',-6 ,currentdate)

Upvotes: 2

Related Questions