Make Date

[#1]

Hi,

I am trying to use Make Date function by Data as :

10042014,11042014,12042014,13042014,150402014,16042014.

Using Script as :

Date:

LOAD

Date( Makedate( Left([Order Date],2), Mid([Order Date],2,4) , Right([Order Date],4)) , 'DD-MM-YYYY') as Date1,

[Order Date]

FROM

And while creating a table its giving the same values.

Thanks

Ankit

[syinarosely]

Hi, 

Need help to convert date in to DD/MM/YYYY

The current format date is 31st december 2020

[mattleblanc]

At the point when YOU USE MAKEDATE you should determine consistently YYYY, MM, DD, at that point you may change over in different configurations