LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sree

Hi Team,

1.How to get the sys date into output ie, by using which node and which function we can load sysdate into in output csv file.
2.How to compare date diffirence between employee jioning date to sysdate

Thanks,
Sree.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mlowe

Hi Sree,

1. add the following to a filter node: emit *, date() as "today"
2. Adding something like the following will calculate the time between dates in a filter node:

daysAtCompany = date().dateSubtract(EmployeeStartDate)

emit *, daysAtCompany

Hope that helps?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sree

Hi mlowe,
Thanks for your help.
first one worked fine. second one getting error .
Source is xlxs file, i given jioning date of the employes like
1/3/2010
1/4/2010
1/5/2010
1/6/2010
1/7/2010
1/8/2010
i want to get from how manys or years employe is working in company.
if possible can you please post some functions or any web link to download doc/any useful info related to date/brain scripting.
Thanks,
Sree.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hi,

It seems like the issue you're having is that the data is coming in as string value rather than being a date type.
So first you'll need to convert the string to a date, and then use code like that which was posted previously.

The attached graph has an example which should help you do what you want.

Tim.
Attachments:
dateManipulation.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sree

Originally posted by: Tim Meagher
					

Hi,


It seems like the issue you're having is that the data is coming in as string value rather than being a date type.

So first you'll need to convert the string to a date, and then use code like that which was posted previously.


The attached graph has an example which should help you do what you want.


Tim.
			

Hi,

Thanks Tim,now its woking fine. can you please send doc/any useful matrial related to lavastorm tool.

Regards,
Sree