Making a new date from existing date

[Anonymous]

Hello Experts,

I am having a date field say Date and number of days say Days. Now I have to create a new date by combining Date+Days.

Example: Date is : 15th Sep 2014 and Days: 20

Now NewDate would be 15th Sep 2014 + 20= 5th Oct. 2014.

Pls suggest.

Is is possible through MakeDate??

Regards,

Balraj

[MayilVahanan]

Hi

Try like this

= Date(Num(Today())+5) 

Or

Date(Today() + 5)

[MarcoWedel]

Date(Date+Days, 'DD MMM YYYY')

[MarcoWedel]

or just

Date(Date+Days)

if you already set an appropriate dateformat in your script variable "DateFormat".

[MK_QSL]

=LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),

  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-9) &

  IF(

  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),

  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '1' or

  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),

  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '21' or

  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),

  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '31','st ',

  IF(

  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),

  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '2' or

  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),

  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '22','nd ',

  IF(

  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),

  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '3' or

  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),

  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '23','rd ','th '))) 

  &

  Mid(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),

  Index(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),' ')+1)

[Anonymous]

Thanks Marco.

Done.