Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date functions not working

Hi All,

I have a field called DateAssign in the database. Its stored in NVARCHAR2(200) format in an oracle database. I am trying to use simple date functions like Year, Month etc but its not working.

Eg.

Load Year(DateAssign) as "YearD";  After the reload nothing is coming up in the YearD field.

Can anyone please suggest anything?

Thanks !

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Before applying date functions you need to format it to date if it is not in standard date format

Example : date format stored in db is MM-DD-YYYY

then

Year(Date#(DateField,'MM-DD-YYYY'))

View solution in original post

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Before applying date functions you need to format it to date if it is not in standard date format

Example : date format stored in db is MM-DD-YYYY

then

Year(Date#(DateField,'MM-DD-YYYY'))

Not applicable
Author

Thanks for your reply. I actually used Year(Date(DateField,'MM-DD-YYYY')), but it didn't work. Don't know the reason.

Thanks again for your reply.

MayilVahanan

Hi

Date#() function takes string and convert into dateformat

Date() function takes number and convert into dateformat..

nVarchar() is string format..So date() function not suitable here..

Regards,

R.MayilVahanan

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.