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

sum date + month

Bonjour à tous,

 

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

Voici un exemple ci-dessous :

 

hcarr01_0-1715781358755.png

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
txnelson
Super User

Re: sum date + month

The formula is

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

txnelson_0-1715782087434.png

 

Jim

View solution in original post

jthi
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)",
	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"))

 

-Jarmo

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: sum date + month

The formula is

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

txnelson_0-1715782087434.png

 

Jim

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
jthi
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)",
	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"))

 

-Jarmo