Date format

[upaliwije]

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

[maxgro · Accepted solution]

for table 1, if you have

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

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

for table 2

makedate(YEAR, MONTH)