Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Date([Duration Date]+[Duration of Project],'MM/DD/YYYY')) AS [PROJECT LINE UP]
Regards,
Antonio
May be like this
Date([Duration Date] + [Duration of Project]) as ProjectEnd,
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
Like this?
HI,
I assume You Date Format is 'D/M/YYYY'
See Attachment.
Regards,
Antonio
Thanks for the kind guidance all