topic Re: Date format in QlikView

Date format

RaimondsR — Sat, 16 Nov 2024 00:45:43 GMT

Hi!

Maybe someone could help me to solve one problem.

Time format, which comes from one report is dd.mm.yy hh:mm:ss (there is space before dd), what i should get is dd.mm.yyyy, maybe anyone could help with this?

At moment tried use those 2 formulas :

Date(Date#( Datums,'DD.MM.YYYY')) as add_date,

Date(Floor(TimeStamp#(Datums,'DD/MM/YY hh:mm:ss')),'DD/MM/YYYY') as add_date,

Bouth formulas returns "-".

Re: Date format

Durgadevikumar — Tue, 12 May 2020 12:50:52 GMT

Hi,

try,

Timestamp(Timestamp#(Datums,'dd.mm.yy hh:mm:ss'),'dd.mm.yy') as add_date

Regards,

DurgadeviKumar

Re: Date format

sunny_talwar — Tue, 12 May 2020 13:22:43 GMT

May be this

Date(Floor(TimeStamp#(Trim(Datums), 'DD.MM.YY hh:mm:ss')),'DD/MM/YYYY') as add_date

Re: Date format

Brett_Bleess — Tue, 26 May 2020 16:02:12 GMT

You have been provided two responses to your question, we would greatly appreciate it if you would close out the thread by using the Accept as Solution button on the post(s) that helped resolve things. This gives the poster(s) credit for the help and lets other Members know what worked. If you still have further questions, or did something else, please leave an update post, and if you did do something else, you can post what you did and use the Accept as Solution button on that post after posting...

Regards,
Brett