Log In

Log In



Not registered yet?


Reset password Activation link

Forums ~ Noticed some issue with QuintaDB?

Reminder based on a date in the past
September 16, 2017
Completed
0
 

dawoudothman@hotmail.com
September 16, 2017

Hello,

I’m trying to create new reminder based on a date in the past, for example if I enter today’s date in a column then
I would need to receive an e-mail reminder after two days. I thought of creating new column with a formula which
calculates the date and I used “+” operation but the result is just the date with the number added as text and not
a new date (with today’s date plus 2 days).

Best Regards
Dawoud



Igor Petrushenko
September 16, 2017

Hi, Dawoud!

Please, just use ‘-2’ days format. No need to use formulas.

And just for the future, you should select your operands types when you work with Formula. You can choose Text, Number or Data as formula operands. By default it will be Text.



Reply:

File attachment (max 10MB)




Share the discussion in the social networks:





Tags

#Android

#CSV

#Can't be blank

#Excel

#Export

#Google

#HIPAA Compliance

#HTML

#IP

#Import

#Mobile

#PCI compliant

#QuintaDB

#SMS

#URL

#access rights

#account

#actions

#activation

#activity

#advanced options

#api

#attach

#autocomplete

#autoincrement

#background

#backup

#birthday

#blocked

#boolean

#browser

#button

#calendar

#captcha

#chart

#checkbox

#clone

#close the form

#cms

#color

#column

#conditional formatting

#confirm

#constant

#cookies

#country

#crm

#css

#custom

#data security

#database

#date

#date & time

#date format

#description

#dropdown

#dublicate

#duplicate

#dynamic form

#email

#example

#extract

#field

#field names

#field type

#file

#file upload

#filter

#font

#form

#form builder

#formatting

#formula

#forum

#free

#ftp

#gap

#geolocation

#grouping

#horizontal

#id

#iframe

#images

#in-place editing

#instruction

#integration

#invite

#java

#js

#language

#limits

#link forms

#links

#location

#log

#login

#logo

#map

#mc access

#members

#moved form

#moved project

#ms access

#multi-input

#multiline field

#multipage form

#multiple

#multiple forms

#mysql

#new features

#new window

#newsletter

#not empty

#notification

#number field

#number of records per page

#number separator

#numbered column

#offer

#offline

#operand

#page break

#partnership form

#password

#payment

#pdf

#phone number

#plan

#popup

#portal

#position

#print

#quotation tool

#radio button

#records

#redirect

#referral program

#registration

#regular expressions

#relationship

#remind

#remove

#rename

#report

#rules

#script

#scroll

#search

#security data

#security menu

#server

#service

#sheets

#show/hide

#side by side

#signature

#size

#sort

#special character

#state

#storage

#subscribe

#suggestion

#support

#table

#team

#template

#text

#text direction

#time

#total

#trial

#tutorial

#two-column

#update column

#update records

#updates

#upload file

#users

#validation

#video

#view

#widget

#window

#wysiwyg

#youtube

#zip code