Detect a date field in a QVD

[fortaleza40]

Hello Community,

I need to detect a date field in the QVD load, i have several fields so load the specific field not works fine, so i need a way to detect a date field automatically even if have string format because the dates are stored in different patterns

[rwunderlich · Accepted solution]

Use Alt() with a number of different patterns as shown in the Help here:
https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...

Also similar to what's discussed here 
https://qlikviewcookbook.com/2019/12/parsing-non-standard-signs/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com