Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Date Formula Post Reply Post New Topic
Author Message
gpmatthews
Newbie
Newbie
Avatar

Joined: 20 Aug 2009
Location: United Kingdom
Online Status: Offline
Posts: 9
Quote gpmatthews Replybullet Topic: Date Formula
    Posted: 23 Jul 2010 at 5:27am
I am trying to get a start date from pre set end date. e.g. we have an end date that is 26/07/10 and i need to show that it is required into production 2 weeks before so 12/07/10. what formula do i need to use?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 23 Jul 2010 at 6:16am
dateadd('d',-14,date(2010,7,26))
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.015 seconds.