Format date include day name

[#1]

Hi all,

Anyone know how to convert or format this date: Wed, 01-July-2011 into this format: 01/07/2011. I have tried this expression:

=date(Date#([myDateField], 'ddd, DD-MMM-YYYY'),'DD/MM/YYYY') but can't work...

Anyone has any idea to do this? Any comments and suggestions are welcome.

Another problem is my database consists a variety of date with different format and those format are unexpected since my date date will always being updated... I am thinking a way to convert those unexpected date format into this format 'DD/MM/YYYY'. But I am not sure is it possible. Anyone has any ideas on this? Please let me know if my questions are not clear...

Thanks a lot.

[#2]

use WWW on the place of ddd

[#3]

ok so what if i have a date feild and i want to have a list box showing only the 7 days of the week, how would i go about doing that

[#4]

Day(dateField)

[Anonymous]

Try below for weekdays,

=WeekDay(Today())

[#6]

Hi there, thanks but it does not show distinct, weekday does however

[#7]

how do i get them to sort chronologically

[Anonymous]

Hi,

You may try below,

date_field = Wed, 01-July-2011

=Date(Date#(Trim(SubField(date_field, ' ',2)), 'DD-MMM-YYYY'))

[kaushalview]

Hi

Use this expression

date(today(), 'DD-MMM-YYYY')&'-'&WeekDay(today())

Regards

Kaushal

[Anonymous]

You can sort them by Numeric Value to get chronological order. Or you may have to create inline table to get this done.