topic Re: Display Correct Date Format in App Development

Display Correct Date Format

prabunakil — Thu, 23 Aug 2018 00:54:28 GMT

Hi All

I have a problem in extracting Birthday Month.

example:

i have different set of date set in database as string for birthday :

Scenario 1: 08.08.2018

Scenario 2: 8.08.2018

Scenario 3: 8.8.2018

Scenario 4: 08.8.2018

How can i set the expression to capture the month = 8.

Please advise.

Re: Display Correct Date Format

rwunderlich — Thu, 23 Aug 2018 01:52:53 GMT

Month(Date#(indate, 'M.D.YYYY')) as Month

The format will pick up both single and double digit Day and Month.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com

Re: Display Correct Date Format

prabunakil — Thu, 23 Aug 2018 02:05:22 GMT

Did not work. result all show as '-'

Re: Display Correct Date Format

rwunderlich — Thu, 23 Aug 2018 03:01:05 GMT

I tested using the data you posted. Can you post the script you tried?

-Rob

Re: Display Correct Date Format

prabunakil — Thu, 23 Aug 2018 03:47:54 GMT

DateOfBirth,

//Month(Date#(DateOfBirth, 'M.D.YYYY')) as BirthdayMonth, <- this suggested by you but no working too.

Mid(DateOfBirth,4,2) as [BirthdayMonth], <- this the one i current using which is wrong.

Re: Display Correct Date Format

rwunderlich — Thu, 23 Aug 2018 04:00:02 GMT

The data in this screenshot shows "-" as the separator in the format pattern. Your first post used "." as the separator. Modify my example to use the format pattern actually used in your data.

Also is looks like it should be day first:

Month(Date#(DateOfBirth, 'D-M-YYY')) as BirthdayMonth

-Rob

Re: Display Correct Date Format

Arthur_Fong — Thu, 23 Aug 2018 04:05:27 GMT

Hi Prabu,

Refer attached and apply the function SubField to grab strings from DOB column.

Thanks and regards,

Arthur Fong

Re: Display Correct Date Format

prabunakil — Thu, 23 Aug 2018 04:18:29 GMT

thank you Rob, is working fine now.