Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Comparing Dates Based on Weekdays

Dear Team,     I would like to script a conditional column to assess that this rule applies, no item created in a given week is getting approved on a date that comes after Monday 12:00 PM next wee...
Need Help
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Please post some sample data as well as results expected. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Well, I don't know what to post actually, they're just 2 columns here, both of dates, one is for the creation date and the other for the approval dates and all I need to make sure of that the approval dates are not coming after the deadline which is set to be every Monday at 12:00 PM. for each week.

    • Vijay_A_Verma's avatar
      Vijay_A_Verma
      Most Valuable Professional
      4 years ago

      So will following formula do?

      =[creation date]<=[approval date]

      This will show False if creation date > approval date otherwise True.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Not really, ok, I’ll give an example, today is the start of the ISOWEEK #22, right? Ok, so, today at 12:00 PM is supposed to be the deadline for last week entries, so, any entries that were created at any point from Monday, 23-May-22 at 12:00 AM till today, 30-May-22 at 11:59 PM should have approval dates that are before today, 30-May-22 at 12:00 PM, otherwise, they are invalidly approved, and that is the conditional column that I need to check, it checks the entries of each week to make sure that this rule applies and provide an input by the end.