Discussion board where members can get started with Qlik Sense.
Is there a formula that can get a date and return it's format?
Input: 31122015 Output: DDMMYYYY
Go to Solution.
Here is what I suggest
If(Num(Date#(DateField, 'DDMMYYYY')) > 0, 'DDMMYYYY',
If(Num(Date#(DateField, 'YYYYMM')) > 0, 'YYYYMM',
If(Num(Date#(DateField, 'YYYYMMDD')) > 0, 'YYYYMMDD',
..... and so on...
You might be able to create one... but the issue will be for an input like this 01022015... is this DDMMYYYY or MMDDYYYY?
Please Use Below Code:
=Date(Date#('31122015','DDMMYYYY'),'Write Your Date Format Here')
Arvind OP is looking to get the format as an output
When the user enters 31122015, they need to see DDMMYYYY
Anything you know that already exists?
Regarding the issue you raised, I guess that is something that will have to be defined as a fixed property. When Day and month can be both, choose X. (Maybe according to country standard format)