nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

sum date + month

hcarr01

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.

TEST.jmp

Accepted answers

txnelson

The formula is

If( Month( :date ) + Num( :"time (month)"n ) <= 12,<BR />Date MDY( Month( :date ) + Num( :"time (month)"n ), Day( :date ), Year( :date ) ),<BR />Date MDY( (Month( :date ) + Num( :"time (month)"n )) - 12, Day( :date ), Year( :date ) + 1 )<BR />)

jthi

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)",
	Add Rows(1),
	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"))

All comments

txnelson

The formula is

If( Month( :date ) + Num( :"time (month)"n ) <= 12,<BR />Date MDY( Month( :date ) + Num( :"time (month)"n ), Day( :date ), Year( :date ) ),<BR />Date MDY( (Month( :date ) + Num( :"time (month)"n )) - 12, Day( :date ), Year( :date ) + 1 )<BR />)

Dan_Obermiller

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!

New Test.jmp

jthi

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)",
	Add Rows(1),
	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"))

hcarr01

Bonjour,

Votre réponse fonctionne pour ajouter les mois. Mais lorsque la somme de la date + le mois dépasse l'année en cours, on obtient un problème (pas de résultat ou l'année ne devient pas l'année +1) :

Ici, le résultat de la colonne "somme" devrait être : 02/05/2025

Comment peut-on contourner ce problème ?

Merci pour votre réponse.

TEST.jmp

jthi

Did you try with the solution I provided?

hcarr01

yes it works correctly !