Forum Discussion

kalpana's avatar
kalpana
Helper I
9 years ago

Need help

Hi   In a particular folder, i want to merge all files(txt files) from sharepoint. i got it for merging all files. but the thing is i want to filter the file if the particular word is present insid...
Need Help
kalpana's avatar
kalpana
Helper I
9 years ago

i tried this formula only i am getting error

 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi kalpana,

 

You want to subtract 1 day from date created, right? If it is, please try the following formula and check if it works fine.

 

New Column = DATE(YEAR([Date Created]),MONTH([Date Created]),(DAY([Date Created]) - 1))


Best Regards,
Angelia

  • kalpana's avatar
    kalpana
    Helper I
    9 years ago

    I Checked it, it s not working fine. i am getting error that date is not recognized