Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
my date and time should be in the format of dd.mm.yyyy 00:00:00 , but when I pull the date from QVD in to QV datamodel file,
I am getting the below image
COMPLETEDUTC is the date with time.
I need to calculate Max and min of Dates.
So, I want to change this number to dd.mm.yyyy 00:00:00, can some one help.
Use this
TimeStamp(COMPLETEDUTC) as COMPLETEDUTC
Date and Timestamps have an underlying numerical value... if you just add TimeStamp() function around your date field, it will get the format you would want. But to calculated min and max, you don't really need formatting function as you can find the min and max of the underlying numerical value which should be the same things as finding the min and max of formatted timestamp
Hi Sunny,
Thank you for the reply,
When I used Time stamp function and see, I got the dates of 2016 also, But I want to load from date 01Jan2017 00:00:00,
Thank you Anil. I got the dates, but not in DD.MM.YYYY format, I got in YY-MM-DD 00:00:00. I think I can manage
Where clause
LOAD ....
FROM ...
Where Date >= MakeDate(2017);
You can use like below
TimeStamp(COMPLETEDUTC,'DD.MM.YYYY hh:mm:ss TT') as COMPLETEDUTC
Hi Sunny,
Awesome!! Thank you very much
It seems you need to load the year data that is 2017 so why not you make it dynamic so you no need to hard code it
Ex:-
Load * From source
Where Date >= MakeDate( Year(Today()) );