
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Convert DateTime format to Date only in Editor
Hi,
I am trying to convert DateTime (2021-01-01 12:18:23) obtained from SQL connection (SSMS) to Date (2021-01-01) only in the script editor.
Tried many proposals from the Forum with no luck. Reverting to the below - but this is not a perfect solution and causes issues elsewhere in the build -
Trying to convert a.alert_date to just Date (as above)
ODBC CONNECT TO SSMS;
SELECT 'WLF Batch' as queue_summary
,Left(a.alert_date,10) as "AlertDATE"
,Day(a.alert_date) as "Alert_day"
,Month(a.alert_date) as "Alert_month"
,Year(a.alert_date) as "Alert_year"
...
Any suggestions?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load *, DayName(alert_date) as AlertDATE, Date(Floor(alert_date)) as AnotherAlertDATE;
SELECT alert_date, OtherFields
From YourTable;
This assumes your date is actually a date field, rather than a string that happens to be formatted as a date. If the latter is the case, you'll need to use date#() to convert it to a date format first, and then apply one of the other function(s).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for the response. I'm not getting it to work though...
Please could you check this out for me and advise?
ODBC CONNECT TO SSMS;
Load *,
DayName(a.alert_date) as AlertDATE,
Date(Floor(a.alert_date)) as AnotherAlertDATE;
SELECT
a.alert_date
,Left(a.alert_date,10) as "AlertDATELeft"
,Day(a.alert_date) as "Alert_day"
,Month(a.alert_date) as "Alert_month"
,Year(a.alert_date) as "Alert_year"
FROM Table1 a
LEFT JOIN Table2 b ON a.ID = b.ID


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry, but I can't check this out for you - it's a query from your database that I don't have access to. What result are you getting, and what are sample input values?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Understood -
Is the construct of my query in order though?
a.alert_date is in format 2021-01-01 12:18:23


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try Dayname(date#(alert_date,'YYYY-MM-DD hh:mm:ss')) - if Qlik isn't reading it as a date, this should force it to do so.
