Dual Date

[smilingjohn]

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

[Vegar]

What's the issue with your script line. It looks ok to me. 

Please explain your issue in more detail.

[smilingjohn]

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 

[Vegar · Accepted solution]

Try this. 

Date( WeekStart( Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY') & ' - ' & Date(WeekEnd(Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY') as start_End_Date