Including Day of the week in the date format

[#1]

Hi All,

I have a timestamp in the format off 'DD/MM/YYYY hh:mm:ss[.fff]'.

I have formatted it group each day together. Date(DayStart([Logged On]),'DD-MMM-YY')  which returns for example 04-Nov-15. However i would like to return Weds 04-Nov-15. How do i this?

thanks,

laura

[Gysbert_Wassenaar · Accepted solution]

Use 'WWW DD-MMM-YY'

[MayilVahanan]

Hi

Try like this

=Date(DayStart(Today()),'WWW DD-MMM-YY')

[sasikanth]

hi

try something like that,

=date(Today() ,'WWW MM/DD/YYYY')