Change date to days

[Feras95p]

Dear all,

I have a file which has a column of date as shown in the attached file I want to add other column to know which day refer to each date.

Any help in that please?

Thanks in advance for your kind support. 

[MarqueeCrew]

@Feras95p,

I'm sorry, but I don't understand the request.  You've got a date of 2016-06-02.  What result value are you hoping to see?

Cheers,

Mark

[RolandSchubert · Accepted solution]

Hi @Feras95p ,

if you need the weekday in a "long" form, you can use the formula
DateTimeFormat([Date], '%A')

This will return e.g. "Saturday" or "Monday".

The abbreviated form ("Mon", "Tue") will be the result of:

DateTimeFormat([Date], '%a')

while 

DateTimeFormat([Date], '%w') 

will retrurn a day number (0 for Sunday, 1 for Monday).

Hope this is helpful.

Best,

Roland

[Feras95p]

The problem is that there is some missing data so the order of the days will be mixed up.

[Feras95p]

I want to have output of which day is match every date for example the 2016-06-02 is Thursday.

[MarqueeCrew]

@Feras95p ,

As @RolandSchubert mentioned, the following formula will return the "day of the week":

DateTimeFormat([Date], '%A')

If you use a FORMULA tool and create a "vString" field, named "Day of Week" using that formula, you'll get the result that you asked for.

Cheers,

Mark