Networkday minus 1

[alex59800]

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 · Accepted solution]

hei

attach is an example of what you asked for

[alex59800]

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