Date Addtion or Time Addtion Function available?

Hello All,

I am new to using the EasyMorph. I can see it has lot of potential and it looks very intersting to work with it.

I have a table with some dates, for which I need to add one day to the existing date field and take it to target.

Also, I have field with time, which I need to add like 5 minutes to the existing field and take it to target.

Is this possible with some function like adddate or addtime? I can find only addmonth function.

Thanks for the help.

Hi @kaleelahamed, welcome to EasyMorph Community!

As in Excel, dates in EasyMorph are numbers, formatted as dates. Such numbers represent a number of days since January 1st, 1900. For instance number 42680 corresponds to November 6th, 2016, because there are 42680 days from January 1st, 1900 to that date.

Therefore, adding 1 day is just adding 1. For instance:

1 minute is 1 / (24 * 60) = 1 / 1440 = 0.000694444444444444444444

Therefore to add 5 minutes just add 5 / 1440.

Here is a sample project: add_days_minutes.morph (2.0 KB)

1 Like

Thanks for the Reply. This is really helpful.

Hi @dgudkov ! I am trying to add 36 months to the date.

I did as above, [Date] + 1095, which is equivalent of 36 months and I am getting this output: 30-Dec-1902. In this case [Date] = 12-Mar-2018.

I am adding 12 months and 24 months and it’s working right.

Is there a way to get it right?

Regards,
AK

Hi @aaykay

EasyMorph has a built-in addmonths function.

As for your example - I just tested it and it worked OK for me:


Test Date addition.morph (1.4 KB)

It seems that you are adding 1095 to zero. Can you please send an example project, which replicates the problem, to our support email so we can check it out?

Regards,
Andrew

Hi!

Thanks for the reply. It worked. Didn’t even make any changes. :slight_smile: