Date

[qlikcheepirishe]

I have one qvw in which i have used inline

I have fields Duration Date & Duration of project

IN Duration of date i have a specific date for ex 01/06/2017

Duration of project such as 5,6,7,8,9 etc

My requirement is the for 01/06/2017 if the Duration of project is 6 then it should display 01/12/2017 in new column

[antoniotiman]

Hi,

Date([Duration Date]+[Duration of Project],'MM/DD/YYYY')) AS [PROJECT LINE UP]

Regards,

Antonio

[sunny_talwar]

May be like this

Date([Duration Date] + [Duration of Project]) as ProjectEnd,

[qlikcheepirishe]

In PROJECT LINE UP I WANT 'MMM/YYYY' HPW COME I CAN COME ACROSS ALSO FOR EX IF THE DOP IS 12 THEN IT SHOULD DISPLAY AS JUN/2018

[Anil_Babu_Samineni]

Like this?

[antoniotiman]

HI,

I assume You Date Format is 'D/M/YYYY'

See Attachment.

Regards,

Antonio

[qlikcheepirishe]

Thanks for the kind guidance all