
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Make Date
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
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
replace your script
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
with
Date:
LOAD
Date(Makedate( Right([Order Date],4), Mid([Order Date],3,2) , Left([Order Date],2)) , 'DD-MM-YYYY') as Date1,
[Order Date]
FROM
from online help
MakeDate(YYYY [ , MM [ , DD ] ] )
Returns a date calculated from the year YYYY, the month MM and the day DD.
If no month is stated, 1(January) is assumed.
If no day is stated, 1 (the 1:st) is assumed.
Examples:
makedate(1999) returns 1999-01-01
makedate(99) returns 0099-01-01
makedate(1992,12) returns 1992-12-01
makedate(1999,2,14) returns 1999-02-14

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load Date(Date#(Date, 'DDMMYYYY'),'DD-MM-YYYY') as Date Inline
[
Date
10042014
11042014
12042014
13042014
15042014
16042014
];
Update : You can create date as below in UI side...
Date(Date#(Date, 'DDMMYYYY'),'DD-MM-YYYY')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
wHEN YOU USE MAKEDATE you must specify always YYYY, MM, DD, then you may convert in other formats :
Makedate( Right([Order Date],4), Mid([Order Date],2,4), Left([Order Date],2) )


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You have to use Date# function to convert text in Date like this :
Date(Date#([Order Date], 'DDMMYYYY'), 'DD-MM-YYYY')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this instead of above
Date(Date#(Date,'DDMMYYYY'),'DD-MM-YYYY') as Date1
Hope this helps.
Regards
Manideep

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hope this will help.
=Date( Makedate( (Right([OrderDate],4)),(Mid([OrderDate],3,2)),(Left([OrderDate],2))) , 'DD-MM-YYYY')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
replace your script
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
with
Date:
LOAD
Date(Makedate( Right([Order Date],4), Mid([Order Date],3,2) , Left([Order Date],2)) , 'DD-MM-YYYY') as Date1,
[Order Date]
FROM
from online help
MakeDate(YYYY [ , MM [ , DD ] ] )
Returns a date calculated from the year YYYY, the month MM and the day DD.
If no month is stated, 1(January) is assumed.
If no day is stated, 1 (the 1:st) is assumed.
Examples:
makedate(1999) returns 1999-01-01
makedate(99) returns 0099-01-01
makedate(1992,12) returns 1992-12-01
makedate(1999,2,14) returns 1999-02-14


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is no need to use MakeDate function for this
Date(Date#(Date,'DDMMYYYY'),'DD-MM-YYYY') as MyNewDate
Regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a Lot.
It worked.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Glad that you have got your desired solution.
Have you tried my solution?

- « Previous Replies
-
- 1
- 2
- Next Replies »