topic Re: Last sunday in App Development

Last sunday

victor_greffet — Tue, 31 Oct 2017 09:13:50 GMT

Hi community,

I'm trying to store the last sunday in a variable called vLastSunday using makedate function, the format has to be DD/MM/YYYY.

Do you have an idea ?

Thanks,

Victor

shraddha_g — Tue, 31 Oct 2017 09:19:13 GMT

Calculate a field with DayName() and use that field in set analysis.

Date(Max({<DayName = {'Sun'}>} DateField),'DD/MM/YYYY')

prat1507 — Tue, 31 Oct 2017 10:20:31 GMT

Maybe this

=Date(WeekStart(Today())-1,'DD/MM/YYYY')

Regards

Pratyush

victor_greffet — Tue, 31 Oct 2017 10:29:25 GMT

Thanks for your answer,

I tried your solution but i was not very adapted to my app.

I finally did :

makeweekdate(year(today(1)) , week(today(1))-1 , 6 )

and it works well