[blackbird]

I have a PM Table name CXO_VISIT_DATE (Fields: CXONAME, STARTDATE, ENDDATE, LOCATION, COMMENT).

Sample Data:

data.PNG (5.86 KiB) Viewed 4915 times

Now I want to get STARTDATE from CXO_VISIT_DATE and want to store in a DateTime (Name: D1) variable. I have a field in Dynaform where I want to show that DateTime by D1.

My Attempt:
@@currentUser_1 --> String
CXONAME --> Varchar

Code: Select all

$uid= @@USER_LOGGED;
@@currentUser_1 = @@USER_LOGGED;

$result = executeQuery("SELECT STARTDATE FROM PMT_CXO_VISIT_DATE WHERE CXONAME = @@currentUser_1"); 
@=DateTimeFromPMTable = $result;

[ashkufaraz]

try this

Code: Select all

@=DateTimeFromPMTable = $result[1]["STARTDATE"];

[amosbatto]

You can't insert case variables inside double quoted strings like normal PHP variables. Instead, you have to first assign the case variable to a a normal variable and then do the insert. Also user IDs are strings, so they have to be placed inside single quotation marks in your SQL query.
Try this:

Code: Select all

$userId= @@USER_LOGGED;
$result = executeQuery("SELECT STARTDATE FROM PMT_CXO_VISIT_DATE WHERE CXONAME = '$userId' ");
if (count($result) > 0) {
   @=DateTimeFromPMTable = $result[1]['STARTDATE'];
}

[blackbird]

Thanks amosbatto.
It's working...

[blackbird]

I want to count the day from given time to CurrentTime.
How can I do that?

My try:

Code: Select all

$userId= @@USER_LOGGED;
$result = executeQuery("SELECT STARTDATE FROM PMT_CXO_VISIT_DATE WHERE CXONAME = '$userId' ");
if (count($result) > 0) 
{
   $now = getCurrentDate();
   @%reminderVar = $result[1]['STARTDATE'] - '$now';
}

[mishika]

Hello,

You can achieve the following by making some changes in your trigger code

@%reminderVar = $result[1]['STARTDATE'] - '$now';

Replace the above line of code with the following:

Code: Select all

$days = strtotime($result[1]['STARTDATE']) - strtotime($now);
@=reminderVar = $days / (60 * 60 * 24);

Hope this helps

Best Regards,
Mishika