I have two files in a flow. Switch can determine the creation dates for both files.
I want to know if the creation dates are more than 30 days apart.
Is there a way to do this?
Compare creation dates of two files
-
- Member
- Posts: 58
- Joined: Mon Apr 05, 2021 8:03 pm
Re: Compare creation dates of two files
A new version of the App Date Calculator will give you the Unix timestamp and from that value you can use Switch Calculations to compare two .
The version 6 of Date Calculator will be published on the Enfocus App Store in the coming days.
https://www.enfocus.com/en/appstore/pro ... calculator
The version 6 of Date Calculator will be published on the Enfocus App Store in the coming days.
https://www.enfocus.com/en/appstore/pro ... calculator
Re: Compare creation dates of two files
Version 6 is now published with the new option that you can use to solve your problem.
-
- Member
- Posts: 58
- Joined: Mon Apr 05, 2021 8:03 pm
Re: Compare creation dates of two files
Thank you Jan this is a great help.
Re: Compare creation dates of two files
Can the app also compare 2 dates? Ex. If date1 X days earlier then date2 , go to ...
Thx
Tom
Thx
Tom
Re: Compare creation dates of two files
No such function but you can do it in Switch in the "Include these jobs" on the outgoing connection from folders.
From the App you will get the TimeStamp as a Private data, this is a numerical value and can easily be compared with another TimeStamp value.
Re: Compare creation dates of two files
I need to compare these two (dates). I need to compare in the format of; checking if one is equal to or less than the other (and neither is today or have any relationship to today) - basically, is this file "overdue":
Is this date the same or *older*
[Metadata.Text:Dataset="pdf",Model="XML",Path="//text[starts-with(.,'Sent: ')]",Search="((\d{1})|(\d{2}))\/((\d{1})|(\d{2}))\/(\d{4})"]
Than this date:
[Metadata.Text:Dataset="XML",Model="XML",Path="/Log/SQLStatementValue/Row/Column[7]"]
I'm getting them formatted mm/dd/yyyy. I just can't "see' how to compare them to determine routing between 2 possible paths.
Is this date the same or *older*
[Metadata.Text:Dataset="pdf",Model="XML",Path="//text[starts-with(.,'Sent: ')]",Search="((\d{1})|(\d{2}))\/((\d{1})|(\d{2}))\/(\d{4})"]
Than this date:
[Metadata.Text:Dataset="XML",Model="XML",Path="/Log/SQLStatementValue/Row/Column[7]"]
I'm getting them formatted mm/dd/yyyy. I just can't "see' how to compare them to determine routing between 2 possible paths.