New answers tagged

0

I'm Not sure that can you achieve this using validation formulas but you can achieve this using SPUtility.js 1.Edit "Edit item" form of your list in browser. 2. Add Script editor web part. 3. Add the following script in script editor and save. <script src="/jquery.min.js" type="text/javascript"></script> <script src="/sputility.js" type="...


5

I wouldn't do this with workflow, I would do this in a PowerShell script that runs on the server, set it up in a Task Scheduler, and let it run every Monday. The script would kick off the workflow that you want, or alternatively use the PowerShell script to compile and send the email instead of the workflow.


2

The OOTB way to do this would be to create your workflow as you want it and add a stage at the end. In this stage put in a Pause action. You can set this for 7 day (or 168 hours). For your Transition to stage, have it redirect back up to the first stage. The downside of this would be that you have to manually start it that first time on Monday. It would ...


0

You have to compare a date to a date, not a string. Try this: =IF([StartDate]>DATE(2016,06,01),"4/26/2017","") Dates can't be set blank through a workflow. It worked fine for me with a calculated field. This also worked fine for me for a "Date and Time" field... it doesn't have to be date only.


0

Please check below options first. StartDate of type Datetime with date only option. Choose The data type returned from your formula must be DateTime. Than Below formula. =IF([StartDate]>=Date(2016,03,31),Date(2017,04,26),Date(2010,01,01))


0

It is because in JavaScript days start at 0 So a text YYYY-MM-DD conversion is converted to numbers giving you a day offset


0

I would try sending the date as UTC. By default JSOM won't convert the date to UTC. If you check your DevTools Network tab in your browser (e.g., in Chrome) you will notice your date would look something like this (under ProcessQuery -> Headers -> Request Payload): <Parameter Type="DateTime">2016-06-08T00:00:00.000-02:00</Parameter>, which will ...


0

Have you tried using a Form Load Rule that populates the datetime fields with "Now()"? You can also try adding code-behind to the InfoPath form to build a Time Zone conversion function. http://www.infopathdev.com/forums/p/25611/88903.aspx


1

Create a local variable of type date/time. Do not assign any value. if condition : If [Contract review Date] is equal to [Local Variable]. This should work for your condition to be working.


3

Date fields are never truly empty, so the option doesn't exist. An "empty" date field is actually set to 1/1/0001. So for your specific project, forget the whole "storing the string values of the dates" thing, that won't work. Instead, set up the workflow to perform the action if Date field is greater than 1/1/0001.


1

Create a new variable, ReviewDateForEmail of type string. Run a check, If [%Current Item:Contract Review Date%] is not equal to 01/01/0001 Set ReviewDateForEmail to [%Current Item:Contract Review Date%] (if desired) Else Set ReviewDateForEmail to There is no set review date for this item. In your email, use the ReviewDateForEmail. This will result in ...


1

Create an initiation variable of type string and don't set a default value. Before you write Contract Review Date to your email, use an if statement to check if the date is greater than 1/1/1900. If it is, use the date... if not, use the null variable.


0

You can use momentjs to do the conversions to the local time. http://momentjs.com/timezone/docs/#/using-timezones/ This is an example from the documentation: var m = moment.tz("2013-11-18 11:55", "America/Toronto"); You'll need to look through the documentation to find out how best to meet your needs.



Top 50 recent answers are included