Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ilanbaruch
Contributor III

date formats

hi all 

based on same field i am creating to date fields one is ok and the other add a '0' prefix.. 

date(datefield ,'YYYYYMMDD hh:mm:ss')

retrieves :

1. 020181026 14:41:28

2. 20181030 17:22:03

any ideas ?

Labels (3)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: date formats

Why are you using five Y's instead of the usual four in your date format string?

talk is cheap, supply exceeds demand
3 Replies
MVP & Luminary
MVP & Luminary

Re: date formats

Why are you using five Y's instead of the usual four in your date format string?

talk is cheap, supply exceeds demand
haupenthals
New Contributor II

Re: date formats

Something like this?

=date(date#('020181026 14:41:28' ,'YYYYYMMDD hh:mm:ss'), 'YYYYMMDD hh:mm:ss')

ilanbaruch
Contributor III

Re: date formats

Thank you for your enlightenment!