topic Re: Date Format in QlikView

Date Format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am extracting data from SAP BW and I have a date field having the format DD.MM.YYYY. I want to change it to MM/DD/YYYY. I have tried using the function below but it's not returning any value. I have also tried changing the DateFormat in the script but to no avail.

date#((Date([Posting date - Posting date Level 01 (Text)],'DD.MM.YYYY')),'MM/DD/YYYY') as [Posting Date]

Re: Date Format

tresB — Wed, 19 Oct 2016 04:34:11 GMT

Try exchanging the date() and date#() position like:

date(Date#([Posting date - Posting date Level 01 (Text)],'DD.MM.YYYY'),'MM/DD/YYYY') as [Posting Date]

Re: Date Format

Anil_Babu_Samineni — Wed, 19 Oct 2016 04:40:24 GMT

You can use simply Date(FieldName, 'MM/DD/YYYY') as [Posting Date];

And do you have timestamp with that field

Re: Date Format

shraddha_g — Wed, 19 Oct 2016 05:06:01 GMT

it should be

date(Date#([Posting date - Posting date Level 01 (Text)],'DD.MM.YYYY'),'MM/DD/YYYY') as [Posting Date]

Re: Date Format

Anil_Babu_Samineni — Wed, 19 Oct 2016 05:08:28 GMT

Shraddha, Tresesco also gave same scenario. Why do you copy same thing. I recommend you to think different approach so that we might learn lot.

- Good Luck

Re: Date Format

nagarjuna_kotha — Wed, 19 Oct 2016 07:19:01 GMT

Like this ?

1. Date(Fieldname,'DD/MM/YYYY') as Date

or else try below one

2. Date(Date#(Fieldname,'DD.MM.YYYY'),'DD/MM/YYYY') as Date

I hope this might helps you.

-Nagarjuna

Re: Date Format

vcanale — Wed, 19 Oct 2016 08:24:02 GMT

Hi,

Try

[ YourField1 ] - [ YourField2 ]
eg:
Date( [ Posting date ] - [ Posting date Level 01 (Text) ], 'MM/DD/YYYY' ) as [ Posting Date ]

Re: Date Format

prabiradhikary — Wed, 19 Oct 2016 08:51:35 GMT

Plz use this

Text(date(Date#([Posting date - Posting date Level 01 (Text)],'DD.MM.YYYY'),'MM/DD/YYYY')) as [Posting Date]

Re: Date Format

sunny_talwar — Wed, 19 Oct 2016 10:10:41 GMT

It would be helpful for you to go over these links

Why don’t my dates work?

Get the Dates Right

Re: Date Format

Anonymous — Wed, 19 Oct 2016 14:27:16 GMT

This is not returning any value.

Re: Date Format

Anonymous — Wed, 19 Oct 2016 14:28:41 GMT

Thanks All!

Re: Date Format

Anonymous — Wed, 19 Oct 2016 14:29:05 GMT

Thank you!