- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to change Date and Time ?
How to change the date & time format when given at the same time like (19-07-2017 03:31:50).
Any one can you please help to change these kind of formats.
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you try this?
LOAD *,
Date(YourDateField, 'DD-MM-YYYY hh:mm:ss') AS ActualDateNum;
LOAD fieldname1,
fieldname2,
Num(Floor(Date#(YourDateField, 'DD-MM-YYYY hh:mm:ss'))) AS yourDateField
FROM yourdatasource;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In these type of format (19-07-2017 03:31:50) if want the date only not the time then what to do?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI Mahendra,
You might be help below:
Num(Floor(Timestamp#([Date Field], 'DD-MM-YYYY hh:mm:ss'))) AS NewDateField
Thanks,
Arvind Patil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
date(DATE#('19-07-2017 03:31:50','DD-MM-YYYY hh:mm:ss'),'DD/MM/YYYY') as date_field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If your variable format same as your date format then you don't need any thing here. Just use Date(FieldName) to get Date and same as Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just load like
Date(Date#(YourdateField, 'DD-MM-YYYY hh:mm:ss'), 'DD-MM-YYYY') AS OnlyDate
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Mahendra,
Date(Date#('19-07-2017 03:31:50','DD-MM-YYYY HH:MM:SS'),'DD/MM/YYYY') as Joining Date
it will returns 19/07/2017
Day(Date#('19-07-2017 03:31:50','DD-MM-YYYY HH:MM:SS')) as Joining Date
19
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=DATE(date#('19/07/2017 3:31:50','DD/MM/YYYY h:mm:ss'),'DD/MM/YYYY')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can go through this,You will get idea
How to Use Simple Date Functions in QlikView and Qlik Sense | EzDataMunch
- « Previous Replies
-
- 1
- 2
- Next Replies »