This content has been marked as final.
Show 2 replies
-
Re: Pre 1900 Dates
Stefan Wühl Oct 20, 2017 6:43 AM (in response to Jacques Hollands)Please don't post multiple times the same request (you may need to wait for approval by moderators)
-
Re: Pre 1900 Dates
Jacques Hollands Oct 20, 2017 6:50 AM (in response to Stefan Wühl )Hi Stefan,
Yeah, apologies for the double-post. It wasn't my intention. I posted my request in the QlikView section the first time and tried to rectify it by putting it into the Qlik Sense section. I then couldn't find a way to delete my original post.
Thanks anyway again for helping me with this.
For those who haven't seen my previous post, Stefan was able to provide me with the following answer that worked perfectly when added to the load script:
Date( Alt(DATEFIELD, Date#(DATEFIELD,'DD-MM-YYYY') )) as DATEFIELD
-