topic Networkday minus 1 in QlikView

Networkday minus 1

alex59800 — Thu, 11 Aug 2011 08:05:15 GMT

Hi All

In my script i connect two differents datas to create a key between two tables.

My key is a date&'/'&salercode

For the date i'm doing a makedate to create a well format date, salercode is a simple code no problem with that.

Here is my point, which must be very easy to do for a qlikview expert:

I need in my key to translate the date loaded in date minus 1 networday for example:

08/082011 which is a monday will be translated in 06/08/2011 (European date)

Anyone for a simple solution ?

Thanks a lot

Best regards

Alex

lironbaram — Thu, 11 Aug 2011 08:50:06 GMT

hei

attach is an example of what you asked for

alex59800 — Thu, 11 Aug 2011 13:22:25 GMT

Thanks a lot Liron;

As i'm curious, I found my answer in Qlik manual but you're right ! Firstwordate(08/08/2011,2) give 06/08/2011.

See you

Alex