idea Re: New functions : isdate, istimestamp in Suggest an Idea

New functions : isdate, istimestamp

simonaubert — Wed, 25 Nov 2020 15:02:35 GMT

Hello,

As of today, the functions istext and isnum exists. However, isnum is true for the date and timestamp fields, which does not seem that natural.

So, I suggest two new functions (or at least one) : isdate and istimestamp.

Best regards,

Simon

Re: New functions : isdate, istimestamp - Status changed to: Open - Not Planned

Patric_Nordstrom — Tue, 21 Apr 2020 12:58:59 GMT

makedate() can be used date tests.

https://community.qlik.com/t5/QlikView-App-Development/A-function-to-check-if-a-field-value-is-correct-date/m-p/533945/highlight/true#M199452

Thanks,

Patric

Re: New functions : isdate, istimestamp

simonaubert — Tue, 21 Apr 2020 15:53:25 GMT

@Patric_NordstromThanks for the answer. However, from what I understand, makedate is used to test if a value can be converted to date. I want to test if my field is a date. This is very different.

My use case is that I have an ETL logic that works in delta. If the delta field is a num or a text, it's cool, the clause just use the value. However, if it's a date, I have to cast it. So, I want something that allow me to say "hey, this field is a date".

Best regards,

Simon

Re: New functions : isdate, istimestamp - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Wed, 22 Apr 2020 14:36:59 GMT

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:49:15 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: New functions : isdate, istimestamp - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:49:16 GMT