topic Re: Mapping two dates in different tables to one table in App Development

Mapping two dates in different tables to one table

freceena — Sat, 16 Nov 2024 01:18:57 GMT

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.

Re: Mapping two dates in different tables to one table

Kushal_Chawda — Mon, 12 Oct 2020 09:44:51 GMT

@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

Re: Mapping two dates in different tables to one table

freceena — Mon, 12 Oct 2020 10:43:59 GMT

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)