topic Re: Dt in QlikView

Dt

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

Hi All ,

I have date formate like below

01-MAY-17 12:45:00

Iam using below script to get like this

01-05-2017 ( wanted to remove the time )

But after reloading this dont show any value

Date(Date#(BillingDate,'DD-MMM-YY hh.mm.ss'),'DD-MM-YYYY')as BDT,

How to rectyfy this

Thanks in Advance

Re: Dt

swuehl — Tue, 03 Oct 2017 09:41:36 GMT

Maybe adjust the time spearator from . to : and use floor()

Date(Floor(Date#(BillingDate,'DD-MMM-YY hh:mm:ss')),'DD-MM-YYYY') as BDT,

Re: Dt

antoniotiman — Tue, 03 Oct 2017 09:43:35 GMT

May be

Date(Date#(BillingDate,'DD-MMM-YY hh:mm:ss'),'DD-MM-YYYY')as BDT,

Re: Dt

smilingjohn — Tue, 03 Oct 2017 09:48:56 GMT

Hi Antonio

This is not giving any output

Re: Dt

its_anandrjs — Tue, 03 Oct 2017 09:50:33 GMT

Try this

Date(Date#(BillingDate,'DD-MMM-YY hh:mm:ss'),'DD-MM-YYYY') as BDT

//Because in your date format is 01-MAY-17 12:45:00

Date(TimeStamp#(BillingDate,'DD-MMM-YY hh:mm:ss'),'DD-MM-YYYY') as BDT

Re: Dt

prma7799 — Tue, 03 Oct 2017 09:51:25 GMT

Try like this

Date(Date#(BillingDate,'DD-MMM-YY hh:mm:ss'),'DD-MM-YYYY') as BDT

Re: Dt

smilingjohn — Tue, 03 Oct 2017 09:52:17 GMT

Hi Stefan ,

THis is working for me , But i dont know if this is the right way please suggest

Timestamp(Timestamp#(left(BillingDate,18),'DD-MMM-YYYY hh.mm.ss'),'DD-MM-YYYY') as BDT,

Re: Dt

swuehl — Tue, 03 Oct 2017 09:54:21 GMT

Why don’t my dates work?

Get the Dates Right

Re: Dt

smilingjohn — Tue, 03 Oct 2017 09:55:35 GMT

I tried all the expression that were suggested but none gives any output

ONly this is working

Timestamp(Timestamp#(left(BillingDate,18),'DD-MMM-YYYY hh.mm.ss'),'DD-MM-YYYY') as BDT,

Should I go ahead with this

Re: Dt

its_anandrjs — Tue, 03 Oct 2017 09:55:55 GMT

John,

Another way with the Left function and then convert to pure date

Date(Date#(Left(DStr,9),'DD-MMM-YY'),'DD-MM-YYYY') as NewDStr

Re: Dt

its_anandrjs — Tue, 03 Oct 2017 09:57:57 GMT

Yes sure it convert your date into pure date with Date function after using slice and dice on the Date fields. Of coursers it works for you.