1. N

    Expression for Yesterdays Date at a specific time?

    I am looking for an expression that displays yesterdays date at a specific time that excludes Sundays - what is the best way to do this? Thank you!! Kyle
  2. G

    Isolate date with Regex

    I’m trying to identify the required regex to isolate a date from a text string. The string is in the following format: January 12, 2020 I need to be able to identify any date of any year. Can anyone help me with this? Thanks in advance
  3. H

    FormatDate() Help Document

    Hi EveryOne, For FormatDate() as Per The help Document (HelpDocument mean When You open the Calculation Stage Click Question MArk it will redirect to Help Document > Studio>StudioUsage>Calculations and Decisions )it is saying FormatDate("02-11-2016 09:23:43", "t") will return "09:23" As...
  4. H

    What is meant by Intervals in DateAdd(),DateDiff(),FormatDate()?

    Hi Everyone, Can some one Please explain What is intervals in DateAdd(),DateDiff(),FormatDate()? Is there any Documentation with example's Please suggest me. Thanks
  5. M

    Calculate Previous Monday As A Date

    Hi All, I need to select a file whereby the file name will reference last Monday and last Sunday in the filename. So For example today is 03/08/2018. The file my process would need to select would include the dates 23/07/2018 and 30/07/2018. I have tried to use calendar objects and such but...
  6. D

    Collection Sort by DateTime different Time!

    When I sort a collection with a DateTime column type the result of the DateTime will be different in the sorted collection. Each row will be 2 hours less, I think there is a problem with the timezone.
  7. K

    Add 7 days to a date

    Hi Team, I have a date and i would be adding 7 days to the existing date if the resultant date is a Sunday or Saturday or any holiday it should postpone the date to Monday or a consecutive date after Sunday or holiday. Thanks and Regards, Prasanth