Date format

[QSense]

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

[#2]

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

[jonathandienst]

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

[jonathandienst]

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