Log in to AnswerLog in to Follow
Gerry
2601Views
15Comments
Solved
Subtract days from date
Question
Is there a function to subtract days from a date? For example, I want something like CurrDate() - 90, or SubtractDays(CurrDate(), 90).
0
0
27 Mar 2012
AddDays( date, -90 )
12
0
27 Mar 2012
This is really cool!! thanks Joop!
0
0
07 May 2014

I am trying to do the same, but when I enter "AddDays(Curredate(), -90)" is not accepted

0
0
12 May 2017

Hi Gonzalo,


You have a typo there. its CurrDate() and not "Curredate()".

Is that the problem or was just writing it here on the forum?


Regards,
João Rosado

0
0
13 May 2017

I have the same issue and the error "Unexpected ',' in expression"


Any idea?


0
0
12 Jul 2018

show your expression Patrick.

0
0
12 Jul 2018
Eduardo Jauch
mvp_badge
MVP

Patrick, please, show your expression, but in a new topic.
Let's not wake the dead ;)

2
0
12 Jul 2018

Is there a function to subtract days from 2 dates?

for example 2019/6/7 - 2019/6/6 = 1

0
0
05 Jun 2019
Marcelo Ferreira
mvp_badge
MVP

Hi,

You have the diffdays action. Check here all the date actions.

Btw normally is better to open a new post than revive a very old one.

Regards,

Marcelo

1
0
05 Jun 2019

Marcelo Ferreira wrote:

Hi,

You have the diffdays action. Check here all the date actions.

Btw normally is better to open a new post than revive a very old one.

Regards,

Marcelo

Hello Marcelo,

Thanks for the reply, 

I just started studying outsystem.


0
0
05 Jun 2019
Marcelo Ferreira
mvp_badge
MVP

Hope you are enjoying it.

Anything you need just ask on the forum.

Have fun

Regards,

Marcelo

0
0
05 Jun 2019

I have one question about that topic.

When I use AddDays(DateCounter,-1) were supposed to subtract one day from de DateCounter, right? I did it and the expression was accepted but browser doesn't open.


Thanks

0
0
08 Apr 2020

Cláudia Dias wrote:

I have one question about that topic.

When I use AddDays(DateCounter,-1) were supposed to subtract one day from de DateCounter, right? I did it and the expression was accepted but browser doesn't open.


Thanks

Cláudia,

what do you mean the "browser doesn't open"?

The datacounter is a variable of date type right?

The return is a date-time variable and not a date variable


0
0
10 Apr 2020

Hi Claudia, 

Please create a new topic for you question. This thread is almost over 2 years old. 

0
0
09 Apr 2020

Hello Everyone...I'm new to Outsystems and this might be an old post
but if anyone could help me out about the same topic..to get 3 days from todays

I tried to use following..
·AddDays(#2021-08-24#, 3)?This showed syntax error
·AddDays(Date,3)?This was not accepted

Thank You all in advance..

0
0
24 Aug
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.