Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two different tables in which date1 is in format of MM/DD/YYYY (11/23/2016) and date2 in format of YYYY-MM-DDT08:00:00Z (2016-11-2T08:00:00). I need to convert these date formats to MMM-YYYY and map value related to date2 to date1. Could anyone suggest a solution for this.
@freceena try below
date(Date#(Date1,'MM/DD/YYYY'),'MMM-YYYY') as Date1
date(floor(date#(subfield(date2,'T',1),'YYYY-MM-DD')),'MMM-YYYY') as Date2
Thank you for reply. I need to map the value related to Date1 to the table having Date2. For example, (Date1, value1) should be mapped in such a way that after mapping we should get (Date2,value1)