Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What's the logic behing converting Nov 30 2015 into a January 2016 date?
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?
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
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
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