Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to two date fields, ARInvoiceDate and TC.ARInvoiceDate. They are formatted as dates in the load script.
I use them in an IF statement in the APP-
=if(ARTransactionCode = 20, (TC.ARInvoiceDate), (ARInvoiceDate))
That becomes a column in a table called Invoice Date.
The problem I have is that when the table is exported to excel, Invoice Date exports as text. The individual fields TC.ARInvoiceDate and ARInvoiceDate export as dates when I use them as columns on their own. When I use them in the above IF statement somehow the format changes to text. I have tried formatting as a dates in the if statement, but nothing seems to work. I am not sure what I am missing on this.
Any help would be greatly appreciated.
Thanks,
Brian
How about if you use Date() function around them
=Date(
If(ARTransactionCode = 20, (TC.ARInvoiceDate), (ARInvoiceDate))
)
Hi Sunny,
Thanks for the reply. I tried it, but no luck. It still exports as text.
regards,
Brian
I tried using two types of expressions and it is showing as date in Excel (The second option):
I am using Qliksense Enterprise June version.
I tried option 2, but it still exports as text for me. I am at a complete loss.
Thanks for the reply.