Help in formula

Discussion in 'Requests' started by sattam, Feb 16, 2021.

    
  1. sattam

    sattam Active Member


    I Want to get the date by condition like this
    if $fileperiod CONTAINS "Jan" then 11-2-currentyear else if $fileperiod CONTAINS "Apr" then 11-5-currentyear else "" like this
    please help
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use......... $$MonthOfDate:$Date = 4 (for April) etc.........
     
    Jaydeep Shah likes this.


  3. sattam

    sattam Active Member


    $fileperiod="Dec-20" I Want to get The Value 11-Jan-2021 from $fileperiod="Dec-20"
    Please Reply
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Increment Month............
    Increment Year, if Month is 12
    Concatenate the string ....to get 11-Jan-2021.

    Study...........VATQuarterBegg and VATQuarterEnd in DEVELOPER.
     
    Jaydeep Shah likes this.


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Also use STRINGPART, if your value is a String...........and Follows a standard pattern....... i.e..... MMM-YY
     
    Jaydeep Shah likes this.


  6. sattam

    sattam Active Member


    Thanks Amit ji Problem solved
     
    bharat shah likes this.


Share This Page