
Specialist
2022-11-16
06:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
how to change a date with timestamp to a date format like DD/MM/YYYY?
Hi there,
I have a date data like below screenshot. how to change a date with timestamp to a date format like DD/MM/YYYY?
Please help!
Thank you.
Jim.
Labels (7)
Labels
- Subscribe by Topic:
-
Data Load Editor
-
Developers
-
dimension
-
expression
-
General Question
-
Script
-
Set Analysis
2,283 Views
1 Solution
Accepted Solutions

Specialist
2022-11-16
09:50 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2,231 Views
8 Replies

Contributor III
2022-11-16
06:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
DATE(ordersubmittime,''DD/MM/YYYY'') AS ordersubmittime,
2,269 Views

Partner - Master
2022-11-16
06:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date(Date#([Order submit time],'DD MMM YYYY hh:mm'),'DD/MM/YYYY')

Contributor III
2022-11-16
07:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if u use this exp the time stamp will disappear right?
2,262 Views

Partner - Master
2022-11-16
08:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Mohan_hitman Please say that again.
2,257 Views


MVP
2022-11-16
04:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In order to get real date values, i.e. only one single integer field value per date, you have to trim the fractional time part of your timestamps or to just interpret the date part of your timestamp strings.
Some possible ways to do this:
table1:
LOAD *,
DayName([Order submitted time]) as [Order submitted date3];
LOAD Timestamp#([Order submitted time],'DD MMM YYYY hh:mm') as [Order submitted time],
Date(Floor(Timestamp#([Order submitted time],'DD MMM YYYY hh:mm')),'DD/MM/YYYY') as [Order submitted date],
Date(Date#(Left([Order submitted time],11),'DD MMM YYYY'),'DD/MM/YYYY') as [Order submitted date2]
Inline [
Order submitted time
01 Sep 2022 12:34
01 Sep 2022 23:45
01 Oct 2022 11:11
01 Oct 2022 22:22
01 Nov 2022 16:36
01 Nov 2022 17:36
01 Dec 2022 01:23
01 Dec 2022 02:34
];

Specialist
2022-11-16
09:50 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Many thanks Brun! this is correct script!
thank you very much!
2,232 Views

Specialist
2022-11-17
02:00 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Macro it helps alot!
2,216 Views

Contributor III
2022-11-17
02:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if u use this exp the time stamp will disappear right?
2,214 Views
