topic Re: Get last friday in App Development

Get last friday

jmialoundama — Mon, 19 Nov 2018 12:14:32 GMT

Hello,

Hello, I have several dates and I wish to recover only the last Friday. Here I wish to recover only the 16/11/2018.

I wrote the following script:

LOAD "RCT - Code",
"Web - Date expedition",
sum("Web - quantité expdiée") as "Qté expédiée vendredi (uniquement)"
FROM [lib://QVD_Rec (omnium_dec1)/DWH\F_EXPORT_CDE_WEB.QVD](qvd)
Where Date("Web - Date expedition")= Date(Weekstart(Today())-3)
Group by "RCT - Code",
"Web - Date expedition";

The function Date(Weekstart(Today())-3) returns well the last Friday which is the 16/11/2018

However when I load my data there is no date of 16/11/2018 coming out of my column

Re: Get last friday

shiveshsingh — Mon, 19 Nov 2018 12:20:51 GMT

Make sure your date format for LHS and RHS match. Please define the Date format using Date# interpreter and Date func

Date("Web - Date expedition")= Date(Weekstart(Today())-3)

Re: Get last friday

jmialoundama — Mon, 19 Nov 2018 12:26:51 GMT

thanks for your reply !

I found where the problem came from.

The problem came from the format of the sate so I had to transform it in the following way:

Where Date(Floor(TimeStamp#("Date expedition",'DD/MM/YYYY hh:mm:ss')),'DD/MM/YYYY')

And it works! 🙂

Re: Get last friday

Vinay39 — Tue, 21 Jun 2022 09:53:28 GMT

but how to get the Friday date automatically when i want daily

eg: for Monday we have took -3, for Tuesday it will change right

then how can we get automatically