Expression Function equivalent to MONTHS_BETWEEN
Is there a SnapLogic expression function equivalent to the SQL function MONTHS_BETWEEN?
I considered using getTime then dividing the difference by 2.628e+9, but it’s not exactly the same.
Forum Discussion
Hey @Prasa,
Try changing the response entity type to TEXT.
Changing to response entity type- TEXT did not help ☹️
hi @nishantagarwal. You can try with Copy snap (placed after directory browser) and Join snap that will be placed just before Email sender snap.
@nishantagarwal Use directory browser and in file filter use . will get all file available in your directory.
Thanks @Supratim . I am not sure if this file name will be available after Parser since file name is needed at very end to pass onto email snap.
Create parent pipeline to browse file in sftp directory, pass file name/path in child pipeline as pipeline parameters.Then file name will be available in your child pipeline all the time.
Thanks,
Supratim
(+91)923-263-3466This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.
