topic Re: Date issue in QlikView

Date issue

bhagi — Fri, 15 Nov 2024 23:49:06 GMT

Hi All,

i have one date fiels

The date in my pivot table should display 11/10/17 but instead I am getting the below result.

1033176:00:00 AM

so what might be the issue?

thanks

bhagi

Re: Date issue

rubenmarin — Tue, 13 Oct 2020 06:44:48 GMT

Hi, probably in the format you are using mm (minutes) instead of MM (months), try with: Date(YourDateField, 'DD/MM/YYYY') - or MM/DD/YYYY if you use that date format

Re: Date issue

Chanty4u — Tue, 13 Oct 2020 08:41:10 GMT

try simple: Date#( YourDate, 'MM/DD/YYYY') as Date

you can try this converting number into date

Date(Num#(Yourdate,'####()'), 'dd/mm/yyyy') as newDate

Re: Date issue

Brett_Bleess — Tue, 27 Oct 2020 15:47:15 GMT

@bhagi you have received two plausible solutions to your question on this thread, we would greatly appreciate it if you return to the tread and close it out by using the Accept as Solution button on the post(s) that helped. If you did something different, please consider posting that and use the button to mark it after you create the post.

Regards,
Brett