cancel
Showing results for
Show  only  | Search instead for
Did you mean:
Choose Language Hide Translation Bar
Level VI

## sum date + month

Bonjour à tous,

J'aimerais faire une somme entre 2 colonnes (date et mois).

Voici un exemple ci-dessous :

Comment je pourrais créer une nouvelle colonne qui aurait pour résultat la somme des deux colonnes et donnerait : "02/09/2024".

La colonne date est en format date j/m/a et la colonne time est en format "mois" avec la personnalisation des formats.

Merci pour votre réponse.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User

## Re: sum date + month

The formula is

``Date MDY( Month( :date ) + Num( :"time (month)"n ), Day( :date ), Year( :date ) )``

Jim
Super User

## Re: sum date + month

You can try using Date Increment() , but you might have to modify your month value (it seems to be character in your case, so use Num() to convert it in a formula).

``````Names Default To Here(1);

dt = New Table("TEST (4)",
Compress File When Saved(1),
New Column("time", Numeric, Continuous, Set Values([4]), ),
New Column("date", Numeric, "Continuous", Format("d/m/y", 12), Input Format("d/m/y"), Set Values([3797452800]), )
);

dt << New Column("a", numeric, continuous, Format("d/m/y", 12), Formula(Date Increment(:date, "month", :time, "actual")));``````

It might also be important to check how your solution works in possible corner cases (Date Increment(31Jan2024, "month", 1, "actual"))

-Jarmo
3 REPLIES 3
Super User

## Re: sum date + month

The formula is

``Date MDY( Month( :date ) + Num( :"time (month)"n ), Day( :date ), Year( :date ) )``

Jim
Staff

## Re: sum date + month

There is no "month" function, likely because months have varying lengths. So I took a brute force approach to create a formula, but I believe it will work. Look at the New Date column in this file. But @txnelson 's approach is MUCH better! I had forgotten about the Date MDY function!

Dan Obermiller
Super User

## Re: sum date + month

You can try using Date Increment() , but you might have to modify your month value (it seems to be character in your case, so use Num() to convert it in a formula).

``````Names Default To Here(1);

dt = New Table("TEST (4)",