topic Multiple date formats in QlikView

Multiple date formats

BarateGites — Thu, 17 Jun 2021 06:56:11 GMT

Just wondering if there is any script that will help me distinguish European date format ddmmyyyy from US date format mmddyyyy? I have an excel document with a date column that contains the two formats(the column itself is formatted as general). Instead of changing excel, is there qlikview script that would allow me to create a new field containing a single format? Thanks.

Re: Multiple date formats

MayilVahanan — Thu, 17 Jun 2021 07:16:32 GMT

Hi Barate,

Try with alt() function

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/alt.htm

Re: Multiple date formats

john45 — Sun, 05 Sep 2021 10:43:52 GMT

try alt function. Im using at my website as well.