Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I have date field its format:DD-MM-YYYY HH:MM
I want to make format such WeekStart-WeekEnd like 19 Jan 2012 - 26 Jan 2012
Below format conversion should help:
=Date(WeekStart(Date(Now(),'DD-MM-YYYY HH:MM')),'D MMM YYYY') & ' - ' & Date(WeekEnd(Date(Now(),'DD-MM-YYYY HH:MM')),'D MMM YYYY')
Replace Now() to your [Date Column]
Note: The output will be a String and no longer be treated as a Date
Hi
You can simplify this (where DateField is the field on which the expression is based, and is a valid date):
=Date(WeekStart(DateField),'D MMM YYYY') & ' - ' & Date(WeekEnd(DateField),'D MMM YYYY')
Regards
Jonathan
As vigi-baba said, this will be a string. If you want this expression to sort properly by date, you could use a dual value:
Dual(Date(WeekStart(DateField),'D MMM YYYY') & ' - ' & Date(WeekEnd(DateField),'D MMM YYYY'), WeekStart(DateField))
Regards
Jonathan