Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am not able to complete this script , can you please help in resolving the below script line ?
Dual(Date(WeekEnd(Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY') & ' - ' & Date(WeekEnd(Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY'))as Start_End_Date,
Thanks In Advance
Try this.
Date( WeekStart( Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY') & ' - ' & Date(WeekEnd(Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY') as start_End_Date
What's the issue with your script line. It looks ok to me.
Please explain your issue in more detail.
Hi Vegar,
This is not generating me the weekend and weekstart date . I want something like below
1Mar20 - 7Mar20
8Mar20 - 14Mar20
15Mar20 - 21Mar20 and so on which I am not getting , The outpu is coming as blank
Thanks
Try this.
Date( WeekStart( Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY') & ' - ' & Date(WeekEnd(Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY') as start_End_Date