DATE format/join

[master_student]

Hello dear community,

I have a date field with that format, how to convert them to date :

1-

2-(january 2016)

I need to convert those field into date add/mm/yyyy and then convert them into number using the autonumber function to link them with my calendar dimension

An other question;

I have 2 tables that are linked by 2 field CDR and LB

buget:

load cdr,LB

resident..

DA:

load cdr,LB

resident ...

I think that by default only the commun fields values are the result of that join, in my case I need all values from the 2 tables to be displayed.

Thanks for you collaboration

[swuehl]

What's the logic behing converting Nov 30 2015 into a January 2016 date?

[sunny_talwar]

To convert to another format, you can try this:

Date(MonthStart(DateField), 'MMMM YYYY') as DateFieldNewFormat

Not sure I understand your 2nd question. Can you elaborate?

[master_student]

NO, you misunderstood me.

I need to convert 31/11/2015 00:00:00 into DD/MM/YYYY

and 01/2016 to DD/MM/YYYY

[sunny_talwar]

May be using Alt function here:

Date(Alt(Date#(DateField, 'MM/YYYY'), Floor(Date#(DateField, 'DD/MM/YYYY hh:mm:ss'))), 'DD/MM/YYYY') as NewDateField

[master_student]

I mean when we have two tables linked by 2 fields, only the common values of those fields are displayed, In my case I need all values of the two tables to be displayed.

I tried Date(MonthStart(DATE_GL),'MM/YYYY') as DateFieldNewFormat but it didn't work.

Thanks