Date format

upaliwije — Sun, 18 Sep 2016 15:59:18 GMT

Hi,

I have two dates in two table in two different formants

Table 1 date1 31-Jan-2016

Table Date1 two different fields YEAR=2016 MONTH=1

I want make tem into uniform format to connect them to master cladender. plsd help me do so in data load script

Re: Date format

maxgro — Sun, 18 Sep 2016 16:05:37 GMT

for table 1, if you have

SET MonthNames='jan;feb;mar;apr;..........';

date( date# (date1, 'DD-MMM-YYYY'))

for table 2

makedate(YEAR, MONTH)